topic Calculating percentages in bar chart in DAX Commands and Tips

Calculating percentages in bar chart

Wassa — Tue, 30 Apr 2024 22:07:57 GMT

Hi,
I'm struggling to display the percentage of the total column on each bar in a grouped bar chart, but I can't find the DAX formula. But in a matrix view, it's simpler by taking the percentage of the column total.

Assuming {A, B and C} represents the COUNTRY column and {Segment 1, Segment 2 and Segment 3} = SEGMENT column.

Thank you in advance.

Re: Calculating percentages in bar chart

lbendlin — Tue, 30 Apr 2024 22:05:25 GMT

If you use 100% stacked bar charts you don't need any DAX.

Re: Calculating percentages in bar chart

Wassa — Wed, 01 May 2024 11:38:42 GMT

Yes, it works with this visual 👌

Thank you for your reply.