Forum Discussion

menphis21's avatar
menphis21
Helper IV
4 months ago
Solved

100% stack using millions format data label

hi i am looking for display data in 100% stacked bar, want to show the number (in detail part) but in millions format but also show the % repartition. I didnt manage to remove the millions format o...
Need Help
Show and Tell
Tips and Tricks
  • rohit1991's avatar
    rohit1991
    4 months ago

    Hii menphis21 

     

    Power BI applies a single formatting rule to data labels in 100% stacked charts, so you cannot show values in millions (M) and percentages (%) with different formats in the same label. The correct approach is to create a custom text measure (e.g., FORMAT(Value/1000000,"0.0") & "M (" & FORMAT(DIVIDE(Value, Total),"0%") & ")") and use it as a label via tooltip, combo visual workaround, or custom visual, because native data labels don’t support mixed formatting.

rohit1991's avatar
rohit1991
Super User
4 months ago

Hii menphis21 

 

Power BI applies a single formatting rule to data labels in 100% stacked charts, so you cannot show values in millions (M) and percentages (%) with different formats in the same label. The correct approach is to create a custom text measure (e.g., FORMAT(Value/1000000,"0.0") & "M (" & FORMAT(DIVIDE(Value, Total),"0%") & ")") and use it as a label via tooltip, combo visual workaround, or custom visual, because native data labels don’t support mixed formatting.