Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi!
If I have a table like this:
How is it possible to create slicer (or preferably ChicletSlicer) in which I could choose from two alternatives. Alternative one would show values from both categories and alternative two would show values from only category 1,
Like this (these are two states of the report):
Great thanks for your help in advance!
-tnmaki
Solved! Go to Solution.
@Anonymous,
Add a separate table for Slicer and use measure below.
Measure = IF ( SELECTEDVALUE ( Table2[Column1] ) = "Category 1", CALCULATE ( SUM ( Table1[value] ), Table1[category] = 1 ), SUM ( Table1[value] ) )
@Anonymous,
Add a separate table for Slicer and use measure below.
Measure = IF ( SELECTEDVALUE ( Table2[Column1] ) = "Category 1", CALCULATE ( SUM ( Table1[value] ), Table1[category] = 1 ), SUM ( Table1[value] ) )
Thanks, Sam!
I guess that would do it!
I ended up doing a separate table like this and using name field in the slicer:
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |