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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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