Total Labels in Stacked Bar Chart Showing Inconsistently

[mmarois123]

When enabling Total Labels in Stacked Bar Chart visuals, the labels will show the correct data format for most bars but will sometimes lose it's formatting. It seems to be when a bar doesn't have more than 1 stack. Example in screenshot below:

[v-xiaoyan-msft]

Hi @mmarois123 ,

Does this problem occur in Power BI Service or Power BI Desktop?
If it works fine in Power BI Desktop but shows up as an exception in Power BI Service, this is a known issue and engineers are working hard to fix it.

Best regards.
Community Support Team_ Caitlyn

[mmarois123]

Hi @v-xiaoyan-msft ,
This happens in both Desktop and Power BI Service. The screenshot is from Power BI Desktop.

[atelkikar]

I am facing a smilar issue, the formatting for the Total labels in a Stacked bar chart is not consistent.

The Y-axis and the Legend values, Date fields (Month, Quarter and Year) and Dimensional fields respectively are added in the visual as Field parameters while the X-axis uses a Calulation group to switch between Amount and Volume measures.

Calculation group:

Measure in the calulation group:

Volume/Amount = SELECTEDMEASURE()

DAX used for dynamic formatting of the calculation group measure:

// To format amount values above a million as $...M, above thousand as $...K, etc.

SWITCH (

    SELECTEDVALUE ( '_Volume/Amount GET Ops'[Name] ),

    "Amount",

        IF (

            [Volume/Amount] >= 1000000,

            "$#,##0,,.M",

            IF ( [Volume/Amount] >= 1000, "$#,##0,.K", "$#,###" )

        ),

    "Volume", "#,###"

)

The result in the Stacked bar chart:

Please let me know if I am doing anything wrong or missing anything. Thanks!