Flag to say when slicer is in use

[AndyDD_UK]

I've two similar questions.

1) If using a slicer panel that is hidden/unhidden via a bookmark, is it possible to have a eg coloured square to denote when users have selected an item(s) from the slicer, when the slicer panel is hidden ?

2) I may use a bookmark to enable users to switch between seeing either table 1 or table 2. If users click on a region in column A in table 1 and that filters table 2 and they then switch to seeing table 2, is it possible to have a eg coloured square to denote that table 1 /2 is being filtered  ?

[Greg_Deckler · Accepted solution]

@AndyDD_UK So you should be able to handle both cases by using a shape visual with conditional formatting using a measure like:

Flag Measure =
  VAR __CountAll = COUNTROWS(DISTINCT(ALL('Table'[Region])))
  VAR __Count = COUNTROWS(DISTINCT('Table'[Region]))
RETURN
  IF(__Count = __CountAll,1,0)

There are also the ISFILTERED, ISCROSSFILTERED and similar DAX functions.