Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
Solved! Go to 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous , both supplier and mode on the x-axis. And sort on them +plus concatenate label off. Check screenshot
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |