Forum Discussion

MonitorA's avatar
MonitorA
Regular Visitor
4 years ago
Solved

Filter ERROR! - how can filter 1 set filter 2 value?

I have two Power BI filters: Flter 1 and Filter 2, I wish to do this: If I click 2018 on filter 1, I whish filter 2 automatically set the value on the same year 2018, if I click 2019 on filter 1, filter 2 auto set its vlaue on 2019 (same year) and the same process will be applied for each year 

Thanks

 

  • Hi, MonitorA 

    If they are slicers on different report pages and created from the same fields, you can consider setting up  Sync slicers.

    Sync and use slicers on other pages 

    Alternatively, you can try filter pane to filter your visual data without slicer.

    Best Regards,
    Community Support Team _ Eason

     

3 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support

    Hi, MonitorA 

    If they are slicers on different report pages and created from the same fields, you can consider setting up  Sync slicers.

    Sync and use slicers on other pages 

    Alternatively, you can try filter pane to filter your visual data without slicer.

    Best Regards,
    Community Support Team _ Eason

     

  • MonitorA's avatar
    MonitorA
    Regular Visitor

    The slicer are on the same page and diffetent tables, and I can't use filter pane.

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support

      Hi, MonitorA 

      Unfortunately, PowerBI does not support the synchronization of slicers corresponding to different fields.

       

      Best Regards,
      Community Support Team _ Eason