Forum Discussion

msimmonsmcse's avatar
msimmonsmcse
Helper I
5 years ago

Block a page filter from applying

I have a report with 6 different visuals. I control the date range that 5 of the visuals use via a page filter. Yet for some reason, on of the filters reports erroneous data when that filter is applied. I want to apply a different date filter for that Visual, and block the Date filter at the Page level from applying to that troublesome visual. Is this possible?

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    msimmonsmcse unfortunately it is not possible, all page level filters will be applied to all the visuals on the page. There is no shortcut, so you should remove the filter you don't want to apply to all the visuals, add this filter to the visual level filter where needed, unfortunately, there is no other way.

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi msimmonsmcse ,

     

    Sorry, for putting the date field in "filter on this page", it will affect all interactive visuals in the entire report. It does not achieve what you expect. For specific explanation, please refer to the official website document.Add a filter to a report in Power BI - Power BI | Microsoft Docs

     

    I think of another way that might help you: put the data field in the slicer, and then  try the "Edit interaction" function in the Format window of the desktop.

    When the "None" visual is selected, the slicer will not interact with this visual. In this way, you may be able to achieve the results you want

    If you still have doubts about this feature, you can refer to the official documentation:Change how visuals interact in a report - Power BI | Microsoft Docs

     

    If the problem is still not resolved, please provide detailed error information. Let me know immediately, looking forward to your reply.

     

    Best Regards,
    Henry

     

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