Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
df123445
Helper II
Helper II

how to group values in a bar chart

I have a table that associates District managers to sales reps:

 

DMSR
DM 1SR 1
DM 1SR 2
DM 1SR 3
DM 2SR 5
DM 2SR 5

 

and so on, I also have a measure that counts sales.

 

I would like to show the data in the following format:

 

df123445_0-1741082271858.png

in a single visual (the screenshot is from Tableau). How can I achieve that? 

The only way I've found so far is to use a stack bar chart, but it's frankly unreadable. 

 

TIA 

1 ACCEPTED SOLUTION
Deku
Community Champion
Community Champion

You can use a matrix, with managers and sales reps as row and court of sales as values. You can use conditional formatting on the counts to generate the bars


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

View solution in original post

1 REPLY 1
Deku
Community Champion
Community Champion

You can use a matrix, with managers and sales reps as row and court of sales as values. You can use conditional formatting on the counts to generate the bars


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.