Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I am using the 100% stacked bar chart. I have data that needs to be stacked as a 100% total, but am looking to see the shifts independently for each set of ID's. Basically a day and night for each 100% stack.
Any ideas?
Solved! Go to Solution.
Hi @Tallone,
Could go and click the "Expand all down one level in the hierarchy" icon on the left top of the visual to see if it will show the result you want?
Regards
Hi @Tallone,
Could go and click the "Expand all down one level in the hierarchy" icon on the left top of the visual to see if it will show the result you want?
Regards
Thank you. There are now three drill down buttons. One of them gave me what I needed.
If you can post the sample data, We would be in better position to provide you a suggestion.
Here is a snapshot of my data. Key field is used throuhout the report as the key field that all other tables link to.
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 64 | |
| 43 | |
| 30 | |
| 27 | |
| 23 |
| User | Count |
|---|---|
| 134 | |
| 114 | |
| 58 | |
| 39 | |
| 35 |