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]))
return
SWITCH (
TRUE (),
currentvalue < 1E3, "#,0",
currentvalue < 1E6, "#,0,.0 K",
"#,0,,.0 M"
)
I tried as well with the classic
SWITCH (
TRUE (),
SELECTEDMEASURE () < 1000, "#,##0",
SELECTEDMEASURE () < 1000000, "#,##0,.0 K",
"#,##0,,.0 M"
)
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 :
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @MorphDustr
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