Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a table that associates District managers to sales reps:
DM | SR |
DM 1 | SR 1 |
DM 1 | SR 2 |
DM 1 | SR 3 |
DM 2 | SR 5 |
DM 2 | SR 5 |
and so on, I also have a measure that counts sales.
I would like to show the data in the following format:
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
Solved! Go to Solution.
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
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
57 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
56 | |
46 | |
40 |