Clustered Bar Chart to Show Percentages Instead of Whole Numbers

[e175429]

Hello All,

This is my current chart:

This chart is based on 5 measures I created, and each measure has it's own total.

Is there a way to show the percentages of the total instead of the whole numbers?

Regards

[Rakesh1705]

While calculating the percentages you can use combination of calculate and all functions so that the Filtering action can be resisted. 

[e175429]

I'm sorry, I'm not sure I understand what you mean

[v-zhengdxu-msft · Accepted solution]

Hi @e175429 

You can just change the outcome of the measure 1 into _result/1405(the measure of the total)

The same to other measures.

Then select the measure and click % button in the Measure tools pane:

Best Regards

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

[e175429]

That did it! 

Thank you soooooo much!

[Rakesh1705]

Hi @e175429 if these are 5 different measures then you need to first add these 5 measures to get a sum up Value and then divide those 5 measures by the sum up Value. Data type of ultimate 5 results will be in  percentage format. I hope you got my point.

[e175429]

Good morning @Rakesh1705 

I do get your point. However, the total of each measure is different.

The sum of the first measure is 1287 but the total is 1405 so I need that bar to show 92%

The sum of the second measure is 998 but the total is 1124 so I need that bar to show 89%

The sum of the third measure is 1219 but the total is 1405 so I need that bar to show 87%

The sum of the fourth measure is 1032 but the total is 1124 so I need that bar to show 92%

The sum of the fifth measure is 1003 but the total is 1124 so I need that bar to show 89%

So if I summed up the measures, I would get incorrect percentages.

[Rakesh1705]

Understood your point. But if you are able to get the percentages separately as per your calculation then keep those percentage measures instead of Value measures in the x axis

[e175429]

I would love to do that if the graph was to stand by itself. But I need to put filter on it, which in turn would change the percentages depending on what is filtered.

[Rakesh1705]

Source Data and % component dax

use the % component at x axis

You will get your desired result

[e175429]

Hey @Rakesh1705 

A couple of things are different for my graph. 

First, it's the product of 5 measures.

Here is my sample data:

I created 5 measures based on this data because I needed to group the sum of certain columns:

First measure:

Second measure:

The next 3 measures follow the same pattern. Let me know if seeing those would be helpful.

I put all 5 measures on a grpah and get:

 My data build is:

When I right click any of the x-axis and select "show value as percent of grand total" it changes the chart to this (I only changed it for the first two):