Forum Discussion
Advanced power bi Filter
Hello, Suppose i have the following dataset: ID, colour 1, Amber 2, Red 3, Amber 4, Red If i create a slicer using the colour, it could return 2 options: Red and amber. I would like th...
Anonymous
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846
AlB
Community Champion
Community ChampionHi Anonymous
One quick solution would be:
1. Add calculated column to the table:
NewColumn =
IF (
Table1[colour] IN { "Red", "Amber" },
"Slice 1",
IF ( Table1[colour] = "Red", "Slice 2" )
)
2. Use NewColumn for the slicer