cancel
Showing results 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.

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

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

1 ACCEPTED SOLUTION
Community Support

Hi @peckerbids ,

OK, I see.

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

3 REPLIES 3
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.

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.

Regular Visitor

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

Community Support

Hi @peckerbids ,

OK, I see.

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

Announcements

#### 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

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors