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

Show categories with zero value on stacked bar chart

 

I created a conditional column that assigned  'Often', 'Sometimes', 'Rarely', or 'Never' depending on the # of times per week a person does an activity. For example, if '# Exercises per week' column = 7-10 , 'Frequency' = Often. Question: how do I create stacked bar charts that show all 4 categories in the order 'Often', 'Sometimes', 'Rarely', or 'Never' , regardless of how many people fell into each category. For example, in the 1st screenshot below, 0 people exercise 'Rarely' - how do I show that category on the graph?

2.JPG1.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
sbelanix Regular Visitor
Regular Visitor

Re: Show categories with zero value on stacked bar chart

Please accept the solution if you find the solution helpful.

View solution in original post

3 REPLIES 3
sbelanix Regular Visitor
Regular Visitor

Re: Show categories with zero value on stacked bar chart

Create another table with frequency details. Use 'Sort By' column to sort the frequency by ID. Create a one-many relationship between parent table and frequency table:

 

sort by.JPG

 

 

relationship.JPG

 

 

1. Take [Frequency] from 'Frequency' table on Axis.

2. Count of ID from 'Frequency' table on Value.

3. Count of Frequency from 'Sheet1'/'Parent' table on Value.

 

 

data values.JPG

 

4. Turn off Legend, X-Axis, Tooltip.

5 Use 'White' data color for [Count of ID] and Blue\Green color for [Count of Frequency]

6 Turn on Data Labels, Turn on Customise series under that and turn off the 'show' button.

 

customseries.JPG

 

You will have the desired output.

 

frequency count.JPG 

sbelanix Regular Visitor
Regular Visitor

Re: Show categories with zero value on stacked bar chart

Please accept the solution if you find the solution helpful.

View solution in original post

Highlighted
Freeland17 Frequent Visitor
Frequent Visitor

Re: Show categories with zero value on stacked bar chart

 

 

This is a huge help!!! Thank you so much! Smiley Happy

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 219 members 2,637 guests
Please welcome our newest community members: