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

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

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 Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors