topic Re: Clustered Bar Chart to Show Percentages Instead of Whole Numbers in DAX Commands and Tips

Clustered Bar Chart to Show Percentages Instead of Whole Numbers

e175429 — Mon, 05 Aug 2024 14:37:05 GMT

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

Re: Clustered Bar Chart to Show Percentages Instead of Whole Numbers

Anonymous — Mon, 05 Aug 2024 16:25:48 GMT

Source Data and % component dax

use the % component at x axis

You will get your desired result

Re: Clustered Bar Chart to Show Percentages Instead of Whole Numbers

e175429 — Mon, 05 Aug 2024 19:44:23 GMT

Hey Anonymous

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

Re: Clustered Bar Chart to Show Percentages Instead of Whole Numbers

Anonymous — Tue, 06 Aug 2024 01:22:17 GMT

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.

Re: Clustered Bar Chart to Show Percentages Instead of Whole Numbers

e175429 — Tue, 06 Aug 2024 13:27:58 GMT

Good morning Anonymous

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.

Re: Clustered Bar Chart to Show Percentages Instead of Whole Numbers

Anonymous — Tue, 06 Aug 2024 13:32:40 GMT

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

Re: Clustered Bar Chart to Show Percentages Instead of Whole Numbers

e175429 — Tue, 06 Aug 2024 13:36:51 GMT

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.

Re: Clustered Bar Chart to Show Percentages Instead of Whole Numbers

Anonymous — Tue, 06 Aug 2024 13:42:10 GMT

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

Re: Clustered Bar Chart to Show Percentages Instead of Whole Numbers

e175429 — Tue, 06 Aug 2024 13:45:26 GMT

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

Re: Clustered Bar Chart to Show Percentages Instead of Whole Numbers

Anonymous — Thu, 08 Aug 2024 07:00:51 GMT

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.

Re: Clustered Bar Chart to Show Percentages Instead of Whole Numbers

e175429 — Fri, 09 Aug 2024 15:20:14 GMT

That did it!

Thank you soooooo much!