Forum Discussion
using one slicer for filtering data from more than one column
I will be happy to know if there any way to create a filter on more than one columns? For example: I have a table with 3 true/false columns (eg A, B, C). I want to create one filter where the us...
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Inbal,
If you don't have other conditions, this is possible. Please check out the demo in the attachment.
1. Create a INDEPENDENT table.
Column1
| A |
| B |
| C |
| AB |
| AC |
| BC |
| ABC |
2. Create a measure.
Measure =
VAR selected =
IF ( HASONEVALUE ( 'Table2'[Column1] ), MIN ( 'Table2'[Column1] ), BLANK () )
RETURN
IF (
ISBLANK ( selected ),
1,
IF (
selected = "A"
&& SELECTEDVALUE ( 'Table1'[A] ) = TRUE (),
1,
IF (
selected = "B"
&& SELECTEDVALUE ( 'Table1'[B] ) = TRUE (),
1,
IF (
selected = "C"
&& SELECTEDVALUE ( 'Table1'[C] ) = TRUE (),
1,
IF (
selected = "AB"
&& SELECTEDVALUE ( 'Table1'[A] ) = TRUE ()
&& SELECTEDVALUE ( 'Table1'[B] ) = TRUE (),
1,
IF (
selected = "AC"
&& SELECTEDVALUE ( 'Table1'[A] ) = TRUE ()
&& SELECTEDVALUE ( 'Table1'[C] ) = TRUE (),
1,
IF (
selected = "BC"
&& SELECTEDVALUE ( 'Table1'[C] ) = TRUE ()
&& SELECTEDVALUE ( 'Table1'[B] ) = TRUE (),
1,
IF (
selected = "ABC"
&& SELECTEDVALUE ( 'Table1'[A] ) = TRUE ()
&& SELECTEDVALUE ( 'Table1'[B] ) = TRUE ()
&& SELECTEDVALUE ( Table1[C] ) = TRUE (),
1,
0
)
)
)
)
)
)
)
)
3. Add it to the Visual Level filter. Don't need to add to the visual.
Best Regards,
Dale
Hi Dale,
THANK YOU for the answer, but unfortunately, this solution is not possible for me. :smileysad:
The idea is that external user will see only 3 options that he can choose from (checkbox: A,B,C) , and not all 9 (in the feature it will be 16=4 ^ 2).
Also, I do not need to show only one parameter, but to display rows in tables that meet the conditions.
Thanks,
Inbal
- v-jiascu-msft
Hi Inbal,
Can you modify my solution? I attached the file. Or how can I modify it to satisfy your goal?
Best Regards,
Dale