Forum Discussion

Michael_Gold's avatar
Michael_Gold
Frequent Visitor
3 years ago

Dynamic Format does not change in graph

Hello,

 

I created a measure with dynamic data type. When my parameter is set to "%" the value appear as a percentage in the table, and while it's set to "ILS" it appears as a number. The problem is that the graph won't show any data when it's set to "%", everything disappears:

 

 

Any way to handle this? I want my to have one graph and my users to be able to choose between % to number.

I can split it into 2 measures and use bookmarks but I want a 'clean' dashboard

Need Help

2 Replies

  • DataInsights's avatar
    DataInsights
    Super User
    3 years ago

    Michael_Gold,

     

    I believe the issue is due to the FORMAT function converting the data type to text. You could try two approaches:

     

    1. Fields parameter (requires two measures; you can format each measure without FORMAT)

    2. Calculation group (the "format string expression" applies the specified format without converting the data type to text)

    • Michael_Gold's avatar
      Michael_Gold
      Frequent Visitor
      3 years ago

      Hi, thank you for your answer, I will try to use calculatin groups