Totaling Issues for Percentages in Stacked Bar Graph

DAX DAX Calculations
1

Hi Everyone,

Included is an image of a stacked bar graph I have showing turnover percentages for my company month over month, stacked by region. (We calculate turnover by TerminatedEmployees/ActiveEmployees.) If you look at March 2022, you’ll see the visual showing a total turnover % of 21.26%. What’s happening is the calculation is just summing up the individual percentages for each region (5.71%, 8.70%, and 6.85%). When, in fact what I want, is for the total to show me the actual total percentage of that month (total terminated/total active), not the sum of those 3 values from each region. In addition, I would like for each region to continue displaying its respective amount, which are currently correct. As any FYI, the actual total should be 4.48% vs the 21.26%.

I’ve searched high and low, watched videos, etc. looking at HASONEVALUE, SUMMARIZE, etc., but I still can’t seem to find a solution. Can someone point me in the right direction here?

Thank you!
Daniel

Stacked Bar Graph Totals
Stacked Bar Graph Totals1246×798 75.1 KB

2

Hi ,

Can you provide your work in progress pbix.

Thanks

3

This has sensitive employee data, so I’m not able to share the file. I’m just looking for some direction on how to fix the totals in my scenario.

4

Well have you looked into these already?

1 Like
5

I have looked through several, but will look again. I know there are so many different ways to “fix” totals and subtotals, but didn’t know if anyone had suggestions with percentages specifically. The summarize/sumx combo is not working for me like it has in the past because of percentages not being “summed”.

6

I understand.
If you’re unable to work it out, I’d suggest to mock up a sample PBIX with dummy data, so members on the forum can provide support.

All the best.

7

Hi @daniel.new, are you able to create a mock pbix file?

Here’s a video that can help you in masking sensitive data:

8

Hi @daniel.new, it’s been a while since we got a response from you. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

9

Hi @daniel.new, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

10

Unfortunately these were not helpful. I was just looking for some direction, if other people had run into that issue. I ended up removing the rollup in the graph due to the data displaying incorrectly. I wish I could send my PBIX file, but it’s against my company’s policy due to trade rights and data security.

11

you can change the data by following the video that was in the message string above. :slight_smile:

12

Hi @daniel.new, have tried the suggestions above on how to mask sensitive file or have you created a mock pbix file so members can help you with your query?

13

Hi @daniel.new, we’ve noticed that no response was received from you about providing a masked or mock file.

We just want to check if you still need further help with this post?

In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.