Pareto Chart.. almost there just missing something

[AaronRogers3]

Hi All,

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!

[v-viig]

Since it's core Power BI Column Chart we would recommend that you should create a topic in Destop thread.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com