Percentage of Parent Total

[Anonymous]

Hello,

I am trying to calculate the percentage of parent total and make a bar chart in Power BI. I am beginner and I am not sure how to do it in Power BI.

I would appreciate If you could advise me on this.

This is how I calculate and visualise it in Excel:

[Anonymous]

@Fowmy  I used the measure and it works! Thank you!

[Fowmy · Accepted solution]

@Anonymous 

Use below measure:

% Parent = 

DIVIDE(
    SUM(Table[Cost]),
    CALCULATE(
        SUM(Table[Cost]),
        ALLSELECTED(Table[Mode])
    )
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[amitchandak]

@Anonymous , both supplier and mode on the x-axis. And sort on them +plus concatenate label off. Check screenshot

[Anonymous]

Hi @amitchandak,

Thanks for your reply.

I've made the changes you mentioned but it only shows total percentage of cost by transport mode. I want to see the percentage of the cost for each supplier by transport mode like I did in Excel.