Display whether a filter is selected

[Anonymous]

Hi there,

Desired solution:

A card (or similar) capable of displaying whether the user has made a selection which is creating a cross filtering context on a report page. 

Detail: 

I currently have a report with a multicard displaying any user selected slicer options. Client is happy with this:

Here is the dashboard page. I would like to create a way of reminding the user whether they have selected any particular date within the time series.

I now need to do the same, but for scenarios when the user has made a selection in a visual that is cross filtering within the report page. So they are clicking on a line in the time series rather than making a selection within a slicer. Is this possible? Don't really want to turn cross filtering off as it's a great feature.

I currently have a clear filters button, too. But this solution would really be very useful.

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario.

Table:

You may create a measure as below.

Iscrossfilteredbyclass = ISCROSSFILTERED('Table'[Class])

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks @v-alq-msft that looks like it may be what I need. So I can likely chain the ISCROSSFILTERED() command with '|' operator to cover all classes possible to select on the report page. 

[amitchandak]

@Anonymous , Not sure I got it. But interactions van help you

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

[Anonymous]

Hi @amitchandak ,

Thanks for the quick response. Turning interactions off is not what I want to do here. 

Many thanks.

[amitchandak]

@Anonymous , can you explain with an example.

I am hoping include, exclude on right-click  does not help you

[Anonymous]

@amitchandak 

I have updated the original question to include an image of the report page. 

You can see that at the top of the page there is a multicard that captures any slicer selection the user makes. I wondered if there was a similar solution for showing whether a user has made a selection within a visual that is cross filtering anywhere on the page. Like a warning card: "Warning, selections are filtering your data". 

I'm unsure what include / exclude on right click refers to. 

Thanks again,

Rich.

[amitchandak]

Just a high level idea

Try to add one card and group it with this visual. With the use of isfiltered or hasonevalue check if the date is filtered and display the message on the card

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-visuals

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

If needed, Remove interaction of this card other than this trend visual