Forum Discussion
Slicer with multiple criteria values
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
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] ) )
2 Replies
v-chuncz-msftCommunity Support
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] ) )