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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
johngabbradley
Advocate II
Advocate II

Slicer Is Not Filtering Based on Visualization

Hello,

 

I am very new to Power BI although I have worked in PP and PQ since their betas.  I am trying to create a very simple visualization with a line graph.  I have data from my payments table which is connected to my date dim table and my users table.  I have the week_num as my vertical access.  However, when I add as a slicer my users, it is not pairing down the users to only the users that have payments from the visualization, it is showing all 3600 from my total org.  

 

In my model with Excel this is not a problem with the pivot table and my slicers, it is only selecting those users that are active in my pivot table that is driving the same visualization.  I can't believe that this is not some really simplistic user error but I am also not sure where I am going wrong.  I want my slicer to only display the users that have payments in the visualization which should be about 10 users instead of having to scroll through all 3600 users to get to the ones I want.  I seem to have the same problem with other slicers like my year and week_number, the slicers are not talking to each other and not talking to my visualization.

 

Hope some one can help.

1 REPLY 1
greggyb
Resident Rockstar
Resident Rockstar

Use the chiclet slicer custom visualization from Microsoft. You can put any measure into the Values section, and that will be used to filter slicer options to only those with data.

 

See a good example video here.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors