Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table with 3 true/false columns (eg A, B, C). I want to create one filter where the user can control the rows presented.
Hi 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.
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
Hi Inbal,
Can you modify my solution? I attached the file. Or how can I modify it to satisfy your goal?
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |