Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
peckerbids
Regular Visitor

Clustered Column Chart Show Percentage of Individual X-Axis Fields

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):

 
 

peckerbids_2-1667854654146.png

 

 

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

peckerbids_3-1667854666546.png

 

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

 

Thanks

 

1 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.

vstephenmsft_0-1668494874990.png

 

 

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.

 

 

View solution in original post

3 REPLIES 3
v-stephen-msft
Community Support
Community Support

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.

vstephenmsft_0-1667876354444.png

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.

Hi @v-stephen-msft 

 

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

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.

vstephenmsft_0-1668494874990.png

 

 

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.

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.