Forum Discussion
andy_scott42
Helper II
Helper IISlicer - Single selection filters two values in table
I have a table that I need to filter by a slicer but the slicer value needs to select multiple criteria. Below is my table and my slicer. If a room has Gender of Both then it can be ...
Thanks Natel.
I used this solution and created an intermediate table https://community.powerbi.com/t5/Desktop/One-selection-in-slicer-filtering-two-values/td-p/489524
For the 2nd solution above, the slicer will be from the Parameters table.
Also, I forgot the simplest solution: Add 2 new columns to your table: "Males Included" and "Females Included". Then have 2 slicers instead of 1.
andy_scott42Helper II
Helper IIThanks Natel.
I used this solution and created an intermediate table https://community.powerbi.com/t5/Desktop/One-selection-in-slicer-filtering-two-values/td-p/489524
andy_scott42 - ah, that is a good solution. :) Also, could do a many-to-many relationship and skip the bridge table.