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.
if creating nother table is an option for you,
here's the pbix : slicer test pbix
I have encountered this problem also and this is how i solved it.
Hope this helps you too
Hi mussaenda,
Your solution seems to be doing what I'm after but could you potentially explain the logic and how it works?
Thank you