Forum Discussion
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 on the %.
There is no display unit on this chart.
thank you for helping
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.
1 Reply
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.