cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
noob8
Frequent Visitor

Adding Totals to Stacked Bar Chart or Workaround

I currently have a Stacked Bar Chart that I was trying to show total values on the right side of the bars. However, after searching through this forum, its my understanding that there is no way to show the totals in such a chart. As a workaround people have suggested using Line and Stacked Column Chart. 

 

My sample data looks like:

 

Example2.PNGSample Data

 

My graph is set up in the following way:

 

Example1.PNG

What I expected to see:

My expected behavior, is that I click on 1 month, and then I see a breakdown by App Suite of anything expiring within 1 month. Then if I click on a specific App Suite, I would expect to see a breakdown based on App Comp.

 

What I Actually See:

As you can see, as is the graph is showing the totals 8, 14, 5, etc.

 

However, when I try to drill down and for example isolate anything expiring within 1 month by App Suite, I get an error. 

 

Question1: Is this behavior possible or is this a constraint of PowerBi? How would I fix the drill down?

 

Workarounds I have tried:

As a workaround, I have shifted my graph in the following form:

- I removed the Suite from the shared Axis.

- In Line Values, I added Count of Comp.

 

Example3.PNG

Actual Results:

This workaround, gives me the ability to click on  a particular month and see the breakdown based on Comp. For example, if I now click on 5 Months. I see the following:

 

Example4.PNG

Question 2: Is there any way to group the last image based on Suite? For example show all the colors in the same area or stacked?

 

I am open to suggestions and other workarounds.

 

Thanks,

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support
Community Support

Re: Adding Totals to Stacked Bar Chart or Workaround

Hi @noob8 ,

Sorry to reply late.

Try this:

1. Create a "Suite" table.

Suite = VALUES(TEST_MOCK_DATA[Suite])

suite.PNG

2.  Create Many-to-one relationship between "TEST_MOCK_DATA" table and "Suite" table.

suite2.PNG

3. Put "Suite" column of "Suite" table in column series.

suite3.PNG

PBIX file attached.

 

Best Regards,

Icey

 

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

View solution in original post

Community Support
Community Support

Re: Adding Totals to Stacked Bar Chart or Workaround

Hi @noob8 ,

 

Is this problem solved?


If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


If not, please let me know.


Best Regards
Icey

View solution in original post

4 REPLIES 4
Community Support
Community Support

Re: Adding Totals to Stacked Bar Chart or Workaround

Hi @noob8 ,

If you don't mind, please give me some data sample or PBIX file without privacy information by Dropbox, OneDrive, GoogleDrive, etc, attach the link.

 

Best Regards,

Icey

 

noob8
Frequent Visitor

Re: Adding Totals to Stacked Bar Chart or Workaround

Community Support
Community Support

Re: Adding Totals to Stacked Bar Chart or Workaround

Hi @noob8 ,

Sorry to reply late.

Try this:

1. Create a "Suite" table.

Suite = VALUES(TEST_MOCK_DATA[Suite])

suite.PNG

2.  Create Many-to-one relationship between "TEST_MOCK_DATA" table and "Suite" table.

suite2.PNG

3. Put "Suite" column of "Suite" table in column series.

suite3.PNG

PBIX file attached.

 

Best Regards,

Icey

 

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

View solution in original post

Community Support
Community Support

Re: Adding Totals to Stacked Bar Chart or Workaround

Hi @noob8 ,

 

Is this problem solved?


If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


If not, please let me know.


Best Regards
Icey

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors