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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

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.

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.

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.

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors