Slicer Is Not Filtering Based on Visualization

[johngabbradley]

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.

[greggyb]

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.