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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Dynamically Updating a Filter Selection Based on Another Filter

Hi

 

Is there a way to dynamically update a filter based on another filter selection event without having a relationship between them? 

 

For ex - There is a Snapshot Selection filter that displays year->month combination.

SnapshotSelection.png

 There is another Event year filter that displays a list of current as well previous years.

EventYear.png

Is it possible to automatically select 2019 as Event Year when Dec 2019 is selected in Snapshot Selection and automatically select 2020 as Event Year when Jan 2020 Snapshot is selected?

 

For a selected Snapshot, The user can then manually change it to any other Event Year from the list.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , refer, if this can help

https://www.youtube.com/watch?v=cyOquvfhzNM

Anonymous
Not applicable

Unfortunately that did not solve the problem. This could have been the solution if the Event Year slicer were to hold different list of items for each snapshot. But in this case, the list of items to choose an Event Year is same for all snapshots, that is from 2014 to 2020. 

 

Now is there a way, we can do some event driven based filter selection?

 

For example, lets say user selects Dec 2019 as snapshot and then selects 2019 as Event Year.

 

1.png

 

Next the user retains the Dec 2019 as snapshot but goes on to select 2018 as Event Year.

2.png

Now if the user selects Mar 2020 as snapshot, is it possible to automatically unselect 2018 and then select 2020 in the Event Year?

 

3.png

 

The user can then retain the same Mar 2020 snapshot but goes on to choose any other Event Year from the list.

Hey @Anonymous 
i also have a similar requirement, so can you please reply if you were able to achieve this anyway
Thanks In Advance,

Nithish

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.