cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filter data using 2 selectors

Hi there,

 

I'm struggling with the following problem :

I have a list of projets for which I display, for a selected year, the budgeted invested amount and the actual spent amount.

 

For a given year I only display the projets for which the budgeted amount is greater than 0.

 

From this projects list I need to let the user choose the ones he actually wants to display.

However I'm not sure how to display the restricted list of projects (those with budget<>0 for the chosen year) in the selector.

 

DawnC_0-1599652215119.png

 

Thanks in advance for your help !

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , In the project slicer, put a visual level filter budget<>0?

For two slicers, but should work for one slicer two

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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , In the project slicer, put a visual level filter budget<>0?

For two slicers, but should work for one slicer two

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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors