Dynamic format bug on Stacked bar chart

[MorphDustr]

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 :

[Anonymous]

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

[MorphDustr]

Hello @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

[MorphDustr]

Hello @Anonymous 

Have you been able to reproduce the issue?

Thanks for your help

[dgarrido]

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!