When you using a dynamic formated measure on a stacked bar chart, the display is not consistent :
The measure I use is :
VAR currentvalue = CALCULATE(SELECTEDMEASURE(), ALLSELECTED('Table'[Dimension]))
currentvalue < 1E3, "#,0",
currentvalue < 1E6, "#,0,.0 K",
I tried as well with the classic
SELECTEDMEASURE () < 1000, "#,##0",
SELECTEDMEASURE () < 1000000, "#,##0,.0 K",
But the result is the same.
My analysis is that if there is a dimension will null values, except for the first one, the dynamic format isn't used.
Example 1 : legend order Yes and No
Example 2 : same graph with reversed legend order :
I tried to restore the scene based on the information you provided, but failed. Can you provide your sample for reference ?
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,Community Support Team _ Ailsa Tao
Here are some data you can use :
I've created a measure :
Measure = sum('Table'[Val])
And set up dynamic formating :
I've added a stacked bar chart :
You can notice that then total on DIm = B is not dispplayed in "Millions"
If you reverse the sort order on the legend :
Now it's the total on Dim = 1 that is not displayed correctly
Have you been able to reproduce the issue?
Thanks for your help
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.