condtional FORMAT_STRING from MDX expression not working on charts

[Anonymous]

Hi everyone,

I have a MDX measure with a conditional format_string value:

I expect to see numbers displayed differently according to the selected [IndicatorType] value:

• if [IndicatorType] = "Units" -> 6.895 (with thousand separator)
• if [IndicatorType] = "Values" -> 6.895,0 (with thousand separator and 1 digit in decimal position)

this particular conditional format_string works on table visuals but does not work on charts. It appears that in charts I do not have any formatting at all and obtain numbers without thousand separators and or decimal places (e.g. 6895)

The issue is related specifically to conditional FORMAT_STRING. If I don't put a case after FORMAT_STRING I can see the proper fomatting in charts as well.

here some data in chart form with no formatting:

hwew same data in table form, with correct formatting:

does anyone have a solution or a workaround for this?

thank you very much,

Pietro