Forum Discussion

JLKM's avatar
JLKM
Frequent Visitor
2 years ago
Solved

Erratic cross-filtering behaviour from table visuals

Hi,   I have a bar chart on Page1 that drillthrough to Page2:   On Page2, I have 2 table visuals: Cases and SLATracking   Relationship of the tables (1:*):   Interaction setting ...
Need Help
  • JLKM's avatar
    JLKM
    2 years ago

    Hi Zhu

     

    I did something just now, which I never tried before. I moved everything from the Filters on all pages (under the Filters pane) to Filters on this page, and everything is working smoothly so far.

     

    If it is the cause of problem, why? What if I really needed Filters on all pages ?

     

    Thanks

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JLKM ，

 

Based on the description of your problem, I ran a test, but my test results would not show your problem.

 

Here is my test result:

1.Drill down to another page:

2.Successful interaction is possible:

You can troubleshoot the problem from the filter's point of view, is there a filter on the page that is causing the results to be affected by the filter and generating that error.

 

Best Regards,
Zhu
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

JLKM's avatar
JLKM
Frequent Visitor
2 years ago

Hi Zhu

 

I did something just now, which I never tried before. I moved everything from the Filters on all pages (under the Filters pane) to Filters on this page, and everything is working smoothly so far.

 

If it is the cause of problem, why? What if I really needed Filters on all pages ?

 

Thanks

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi JLKM ,

     

    l'm glad to hear that you solved the problem of unsuccessful interactions through your own attempts. You need to know the scope of filters on this page and filters on all pages, filters on this page only work on all visual objects on the current page while filters on all pages are report level filters that will globally filter the entire report, if you need to use it, you may need to check if the filter will have an impact on some interactions first.

     

    Here are helpful links for you:

    Solved: Difference between page level filter, report level... - Microsoft Fabric Community

    Understanding Filters in Power BI – Davidson Technology & Innovation

     

    Best Regards,
    Zhu
    Community Support Team

     

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