Forum Discussion
Advanced power bi Filter
Anonymous
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846
hi @AlB
Thank you for your answer. Unfortuantely its not exactly what I am looking for. The if statement will evaluate the colours column and there are only 2 possible colours which are amber and red. As the first if statement checks for red and amber colours, it will always return true. The second if statement will never get a chance to execute as a result of that.
When i drag the new column to the slicer, it will only show slice 1 in selection box.
One thing I did was to add "Color is Red" as a visual level filter on the slicer. Then it only shows the option to filter Red items, but clicking off of it goes back to all items. You may also want to use a custom visual like the Chiclet Slicer.
I'm curious, why would "Select All" be too confusing for your use case? It seems pretty straightforward to me. It could even be combined with the visual level filter from above so that the slicer only shows "Select All" and "Red", but works as you describe.