Slicers Behavior

[Anonymous]

Hi Everyone,

I need help on how my month slicer is affecting other slicers on certain months.

If I have my slicer set to January or February as shown in the picture, the PU Slicer shows values. However for all other months, the PU slicer becomes blank.

Is there a reason why this is doing this or a solution?

[Anonymous · Accepted solution]

Hi, 

Thanks for the solutions @ToddChitt  and @lbendlin  provided, and i want to offers some more information for user to refer to.

hello @Anonymous , based on your description, you can set the interactions withe the slicer, fiest, click the month slicer, then click 'Edit interactions' in format.

Then click 'None' icon for the PU Slicer.  then the PU slicer will not affected by the month slicer.

And you can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop#enable-the-visual-interaction-controls

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ToddChitt]

Take a look at the relationships you have defined in the Model view (left side). It may be possible that January and February are the only months where data for those other slicers shows up. Do you have relationships set to filter BOTH? That may be your problem. 

Suppose I sell red widgets and blue widgets. In January and February, I sold some of both. When I slice the fact Sales table by Month, there are sales for both red and blue widgets. But in March, I only sold red widgets. AND ther relationship line between fact Sales and dim Color is allowing fact Sales to FILTER dim Color. So if I slice Sales to only March, there are only red widgets sold, and THAT slices dim Color to only show red as an available option. As soon as I sell only ONE blue widget in that month, then that color becomes available in the slicer.

Hope that helps.

[lbendlin]

if these slicers are fed from columns in the same table then they will impact each other.  Feed your slicers from the dimension tables, not the fact table.