Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join 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
| User | Count |
|---|---|
| 22 | |
| 20 | |
| 20 | |
| 19 | |
| 11 |
| User | Count |
|---|---|
| 62 | |
| 55 | |
| 46 | |
| 45 | |
| 34 |