Forum Discussion
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. Possible?
thanks,
Keith
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
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!
4 Replies
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!
Could I re-visit this issue briefly? I have dynamic formatting working fine in a line chart, but want it to work on the y axis only and not on data labels. It does not change to millions on the axis. Here's the formula:
IF([MSPriceMax] < 1000000, "$#,.K", "$#,,.00M"). Here's how it looks:
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
Yes this is the right direction for me thanks!
