Visualizing FORMAT with 4 decimal places on a bar graph

[Smackcat]

Hi experts!

I have a "M" measure, and I have applied FORMAT( Value, "#,##0.0000") to show 4 decimal places when switching to M. Neverthless, when I try to show M on a bar graph it can't be showed, so I don't get any bar because of the format on M measure 😞 

Any advice on this? Is it possible to show FORMAT with X decimal places on a visual graph? Thanks.

[Ritaf1983 · Accepted solution]

Hi @Smackcat 

Hi  

Function "Format" Changes your measure data type to text.
You can use
1.If the format is static, then generic graph format options

2. For dynamic formats, use "dynamic string formating" to achieve your goals.

Please refer to the linked discussion. There is an example attached with instructions on how to modify it.

https://community.fabric.microsoft.com/t5/Desktop/How-to-dynamically-format-numbers-currency-and-abb...

https://community.fabric.microsoft.com/t5/Desktop/How-to-dynamically-format-numbers-currency-and-abb...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Smackcat]

Thank you @Ritaf1983 This was very useful 🙂

[Ritaf1983]

Glad to Help 🙂