Clustered Column Chart Show Percentage of Individual X-Axis Fields

[peckerbids]

Hi,

I'm currently making a dashboard that requires me to show the percentage of each current x-axis field like so (made on excel):

But I'm currently getting something like this, where it shows percentage of grand total instead:

How would I be able to transform the bottom graph to something similar to the top?

Thanks

[Anonymous]

Hi @peckerbids ,

Yes, it's possible. Did you try to show the value as percent of grand total?

And this is the percentage grouped according to the x-axis field.

If you still have doubts, please provide me with some sample data and expected results.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[peckerbids]

Hi @Anonymous 

Thanks for the reply! Unfortunately, that's not what I'm looking for. I'm trying to show the percentage of each member of each individual field, not grand total. In your case it is A and B individually. So, for example, in A, it would be 20% 20% 20% 40% instead of 10% 10% 10% 20% (since the total is 10, and they are taking the 2 out of 10). For B, it would show 10%, 20%, 30%, 40% (for the same reason). 

Would that be possible?

Thanks

[Anonymous · Accepted solution]

Hi @peckerbids ,

OK, I see.

Please create a measure like

Measure = var _total=CALCULATE(SUM('Table'[Number]),FILTER(ALLSELECTED('Table'),[X axis]=MAX('Table'[X axis])))
return DIVIDE(SUM('Table'[Number]),_total)

_total is to sum total group by the ID of x axis.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.