Is there a way to toggle a text box to show "Data Filtered" or "Data Not Filtered" ?

[EaglesTony]

Hi,

  I have 6 slicers and 3 pie charts on my report.

  What I want to do is if any 1 of the 9 objects above are selected (i.e. Item in the slicer is selected or a slice of the pie chart selected) then to show "Data Filtered" and then when they are toggled off, to show "Data Not Filtered".

  I was thinking if there was some sort of event I could check on the report and then check the selected values of each ?

Thanks

[jgeddes · Accepted solution]

One way to do this is to create a dynamic title measure which uses ISFILTERED or HASONEVALUE (or similar). Use the created measure in the conditional formatting field for the title of the measure. 

Here is a quick example...