cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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

@tjza , refer, if this can help

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

@tjza , refer, if this can help

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

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.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors