Dynamic Format does not change in graph

[Michael_Gold]

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

[DataInsights]

@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]

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