Forum Discussion
Display whether a filter is selected
- 6 years ago
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 , can you explain with an example.
I am hoping include, exclude on right-click does not help you
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.
- amitchandak6 years agoSuper User
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