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.
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:
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |