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 :
4 Comments
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 TaoHello Anonymous
Here are some data you can use :
Val Dim Cat 1200000 A Cat1 900000 A Cat2 900000 B Cat1 1200000 B Cat2 I've created a measure :
Measure = sum('Table'[Val])And set up dynamic formating :
SWITCH ( TRUE (), SELECTEDMEASURE () < 1000, "#,##0", SELECTEDMEASURE () < 1000000, "#,##0,.0 K", "#,##0,,.0 M" )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
Hello Anonymous
Have you been able to reproduce the issue?
Thanks for your help
- Hello guys. Have the exact same situation. Really struggling here to understand this PBI bug/issue and to find how to solve it. Any news/solution or idea/direction on this topic? Thank you all in advance for your help!
