Forum Discussion
Custom Number Format Preview Different From Visual
This is driving me crazy. I simply want to display 100000 as $100K+.
I created a simple scalar measure (measure = 100000). I used the custom number format and the preview displays what I want.
But then, using any visual type, it does not display the custom number format like the preview:
Any ideas?
Anonymous I did the format to $#,##0"+" and changed to auto and getting this:
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
9 Replies
Anonymous I did the format to $#,##0"+" and changed to auto and getting this:
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Thank you - you're my hero. That solved my problem, but I think AlexisOlson is right though that there's a bug.
This seems like a bug.
Using "$#,##0," returns "$100" as expected but putting text after that final comma causes problems when setting the format string for the measure whereas defining the measure as FORMAT( 100000, "$#,##0,K+" ) acts as expected.
Anonymous what is in the preview that you are not seeing with the actual measure?
Anonymous on format pane, what is the display unit set to?
Anonymous how about auto?
