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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss 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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

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.