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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I have a 2 dropdown slicer Organization and Type
I used Stacked Column Chart in Visual
Axis: Date
Legend: Type
Values: Duration
If I choose All for Organization in my slicer
and Staff in the Type Slicer
It shows me a visual of 3 different color by organization
Legend Organization :Engineering,IT, BA, CAD
But If I choose Type "All" and Organization "Engineering"
I want to see in my visual of with the legend Type: Staff, Contractual, Tempory
So still it will be easy to identify even if I choose All each category.
Is it possible to have a visual condition where if I select All for type it shows me visual with legen of type
and if I select all organization it will show me the visual with the legend of orgnaziation
Or is there any other way so It will be easy identify it? thanks.
Hi, @tebtim19
Sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Community Support Team _ Eason
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 62 | |
| 50 | |
| 41 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 124 | |
| 108 | |
| 47 | |
| 28 | |
| 27 |