Reply
Frequent Visitor
Posts: 9
Registered: ‎01-19-2017
Accepted Solution

Dynamic measure when you deselect a slicer

Hi guys, Is it possible to change measure displayed on a report when you deselect all values in a slicer. Currently, it returns the total value for the measure but I want it to change to a specific value if the slicer is deselected.

Accepted Solutions
Highlighted
AlB Super Contributor
Super Contributor
Posts: 1,188
Registered: ‎11-12-2018

Re: Dynamic measure when you deselect a slicer

Hi @tobz

 

You can use ISFILTERED(Table[Slicer Column]) to check whether nothing is selected on the slicer

View solution in original post


All Replies
Highlighted
AlB Super Contributor
Super Contributor
Posts: 1,188
Registered: ‎11-12-2018

Re: Dynamic measure when you deselect a slicer

Hi @tobz

 

You can use ISFILTERED(Table[Slicer Column]) to check whether nothing is selected on the slicer