cancel
Showing results for
Did you mean:
Highlighted
New Member

## Percent of row in a bar chart

Hi,

I created a matrix table with a % calculation summing up the total per row.:

I now want to visualise this in a bar chart. I’m not getting any further than this:

It looks fine, but the calculation  is different from the matrix table. In the chart every category is a % of the grand total, whereas I need it per row. In the matrix “VPD  - On Time” is 88,96%, in the chart it’s 22,92%. How can I have the same as in the matrix?

In the chart calculation, I can only select "Percent of grand total":

What I actually want to see is "Percent of row total" as you can do in an Excel Pivot Table.

Many thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

## Re: Percent of row in a bar chart

Hi @Spidy_78 ,

Im not certain what your data model looks like, but I have tested it based on my established data model:

1. If you want to show the same percentage as in the matrix, you need not to select Percent of grand total, just put the field in the Value tab(default No calculation)
2. If you just want to show the total row percentage which is like the matrix shows, you can drill up your visual to try

Best Regards,

Yingjie Li

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

3 REPLIES 3
Super User II

## Re: Percent of row in a bar chart

Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!

Super User IV

## Re: Percent of row in a bar chart

You can create % of grand total

https://community.powerbi.com/t5/Desktop/Percentage-of-grand-total/td-p/297356

https://community.powerbi.com/t5/Desktop/percent-of-grand-total/m-p/59029/highlight/true#M24185

In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin

Microsoft

## Re: Percent of row in a bar chart

Hi @Spidy_78 ,

Im not certain what your data model looks like, but I have tested it based on my established data model:

1. If you want to show the same percentage as in the matrix, you need not to select Percent of grand total, just put the field in the Value tab(default No calculation)
2. If you just want to show the total row percentage which is like the matrix shows, you can drill up your visual to try

Best Regards,

Yingjie Li

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

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors