Chart Display Units

[KeithNeedsHelp]

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

[TotunG · Accepted solution]

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

[Dhairya · Accepted solution]

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 below

If 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]

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:

[KeithNeedsHelp]

Yes this is the right direction for me thanks!

[TotunG · Accepted solution]

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