3 Replies Latest reply on Jan 12, 2017 6:52 AM by Théo Fossé

    Date conditional formatting based on parameters

    Théo Fossé

      Hello,

       

      I have a workbook (file attached) in which my users can select the time granularity they want (daily, weekly, monthly, quarterly) to visualize their data. In this respect, I created a parameter "Time granularity" and a Date Selector calculated field that takes the user's choice into account and use the chosen granularity.

      My issue is that I would like this date to be conditionally formatted : for instance if my user chooses "Months", I'd like to display a monthly formated date : January 2016, February 2016, ... instead of 01/01/2016, 01/02/2016, ...

      I assume this has to be done through "personalized date format" (image below), but I couldn't find any documentation or use-case on it...

       

      I have the same problem in other workbooks in which I'd like to conditionally format the KPI my users choose, but I guess it will be the same solution !

       

      Regards,

      Théo

       

      Date.PNG