Solved: 100% stack using millions format data label

menphis21 · ‎04-06-2026

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

rohit1991 · ‎04-06-2026

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.

Did it work? ✔ Give a Kudo • Mark as Solution – help others too!

View solution in original post

rohit1991 · ‎04-06-2026

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.

Did it work? ✔ Give a Kudo • Mark as Solution – help others too!