I am very close to achieving a successful pareto chart however i am missing something and it is causing a problem for me.
Here is my data:
What I am trying to achieve is a pareto chart to show the duration hours vs the room number.
The DAX for TotalAmount = SUM(ENGINEER_TABLE[DURATION_HOURS])
The DAX for Cumulative Percent = [DURATION_HOURS] / [TotalAmount].
Here is the graph at the minute:
As you can see it is calculating the percentage total correctly... however why is it not to 100 percent at the right hand side?
Please help, Thanks!
Since it's core Power BI Column Chart we would recommend that you should create a topic in Destop thread.
Microsoft Power BI Custom Visuals
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.