Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

FILTERS not filtering based on available data

Dear all,   I have a report consisting of:   - A date sheet maintained from 2016 till 2023 (for historical and future maintenance perspective) - A fact table containing dates from 2019-2021 Rel...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, Anonymous 

     

    You are able to make interactions between different visuals or use slicer to filter visuals. But it is not possible to use visuals to filter slicer.

    The workaround is that you manually check the year of the slicer from 2019 to 2021, or use the year of the fact table as the slicer instead of the year of the dimension table.

     

    For reference:

    https://community.powerbi.com/t5/Issues/Slicer-not-responding-to-row-selection/idi-p/527914

     

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Either join is missing or inactive.

Or

You have created a measure with +0  , remove that. Or handled isblank

 

Or in viusal you have used "Show Item with No Data", disable that