Forum Discussion
KeithNeedsHelp
2 years agoFrequent Visitor
Chart Display Units
Hi, I have data ranging from a few hundred thousand to a few million. In one chart I would like my display units to show for example 200K, 400K, 600K, 800K, then switch to 1M, 1.2M, 1.4M, etc. Poss...
- 2 years ago
Not sure on your exact data layout but could potentially look into dynamic string formats?
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings
- 2 years ago
Hey KeithNeedsHelp
Yes it is possible with the new Dynamic string format
I recreated your scenario please follow below step to achieve your requiremnet
Input Data
Step 1: Create a simple measure
Step 2: Go to Dynamic format
Step 3: Now type the condition in the format you want the end output
Now you will get your expected output as belowIf this helps ypu then please kudo this post and mark it as a solution so that others can find it quickly while facing the similar issue. Thank You!
KeithNeedsHelp
2 years agoFrequent Visitor
Yes this is the right direction for me thanks!