Forum Discussion

shantupm5's avatar
shantupm5
Helper III
3 years ago

Slicer for Measure

Hi Team,

 

Is there a way we can add measrues to slicer and filter the data set.

And from the slicer, can we add naviagation features to the slicer? Please advice

 

Regards

Prashanth

 

 

 

 

 

 

 

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • johnyip's avatar
    johnyip
    Solution Sage
    3 years ago

    Generally, yes, it is possible, but not directly. You have to use a column from parameter table for the slicer, and write a DAX measure (that is linked to your measure) that listen to that slicer.

     

    The DAX measure will then do the calculation based on your slicer's selection, returning 1 or 0 based on true or false. And then you will use that measure  as the filter of "filter for this visual".

     

    But this depends on different cases. A specific answer cannot be told if there is no specific case (data, desired result) provided.