Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Slicers Behavior

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?

 

 

 

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.

  • ToddChitt's avatar
    ToddChitt
    Super User
    2 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.