Show % in clustered column chart in Power BI

[YYlee]

This is my excel database plug into Power BI:

This is in Power BI that I unpivot them and add a custom column:

I would like to have each TB at total of 100%

Appreciate for help.

Regards, YY

[Ashish_Mathur]

Hi,

This pattern should work

Total = sum(Data[Value])

Share = divide(calculate([Total],calculate([Total],all(Data[Custom])))

Hope this helps.

[YYlee]

thank you for your help...I am sorry...This does not work...

[Ashish_Mathur]

You are welcome.  Share the download link of the PBI file.

[YYlee]

Thank you dear! I have successfully made with with another friends below assistance! Thank you for your offering!!

[Bibiano_Geraldo · Accepted solution]

Hi @YYlee ,
On top of your measure or column dropped in Y-Axis field, please right click on top of it, and show values as percent of grand total as shown bellow, this avoid to create another measure:

If you prefer to create a measure to calculate a percente of grand total, follow this steps:

1- make sure that you have a measure total pax, something like this:

Sales Amount = SUM(financials[Gross Sales])

2- Now you can create another measure for percent of grand total and put in your Y-Axis:

% of Total = 
VAR total = 
    CALCULATE(
        [Sales Amount], --REPLACE WITH YOUR TOTAL PAX MEASURE HERE
        ALLSELECTED(financials[Segment],financials[Product]) --PUT THE COLUMN OF YOUR X-AXIS AND OF THE LEGEND
    )

RETURN
    DIVIDE(
        [Sales Amount],
        total
    )

Now make sure that the data labels of your visual are enabled and expand y-Axis and set the range Minimum to 0:

This is th finaly result in both scenarios:

[YYlee]

Dear, I am able to % if the total chart is 100%, but I would like each "segment" is 100%. Any way can I make it?

[Bibiano_Geraldo]

Hi @YYlee ,

In above DAX, just remove the segment in ALLSELECTED function, something like bellow:

% of Total = 
VAR total = 
    CALCULATE(
        [Sales Amount], --REPLACE WITH YOUR TOTAL PAX MEASURE HERE
        ALLSELECTED(financials[Product]) --PUT column used in your LEGEND field
    )

RETURN
    DIVIDE(
        [Sales Amount],
        total
    )

As you can see now, each segment is 100%:

[YYlee]

Thank you dear! Is successfully!! I use the 1st DAX you sent me, and use distinctcount for my total pax!! Thank you!

[Bibiano_Geraldo]

Happy it works @YYlee