Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Display whether a filter is selected

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.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.

 

 

1 ACCEPTED SOLUTION
v-alq-msft
Community Support
Community Support

Hi, @Anonymous 

 

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

Table:

h1.png

 

You may create a measure as below.

 

Iscrossfilteredbyclass = ISCROSSFILTERED('Table'[Class])

 

 

Result:

h2.png

 

 

Best Regards

Allan

 

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

 

View solution in original post

7 REPLIES 7
v-alq-msft
Community Support
Community Support

Hi, @Anonymous 

 

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

Table:

h1.png

 

You may create a measure as below.

 

Iscrossfilteredbyclass = ISCROSSFILTERED('Table'[Class])

 

 

Result:

h2.png

 

 

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
Not applicable

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
Super User
Super User

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

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

 

Interactions.png

Anonymous
Not applicable

Hi @amitchandak ,

 

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

 

Many thanks.

@Anonymous , can you explain with an example.

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

Anonymous
Not applicable

@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.

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors