Forum Discussion

shaileng's avatar
shaileng
Frequent Visitor
8 years ago
Solved

Question on incremental filter

Need some suggestion and not sure whether Power BI supports this -   Basically does Power Bi support incremental filters ? For Eg. I have 3 grids on my report. First one shows the list of countries...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi shaileng,

     

    >>However now let say I want check out how many people play Tennis in USA then I would select Tennis in 2nd grid but the moment I do this the filter from 1st grid goes away and it ends up showing me Tennis details for all countries and not for USA as the filter applies only on 1 vizualization.

    Do you means the visual highlight filter effect?  If this is a case, current it only works on active visual, so if you click and active on other visual, previous filter effect will be lost.


    For your requirement, I'd like to suggest you to create slicers with these specific column which you needed to filter on visuals.

     

    BTW, current power bi use 'and' logic to link filter/slicers, you can't direct achieve 'OR'/'NOT' filter on visuals.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi shaileng,

 

>>However now let say I want check out how many people play Tennis in USA then I would select Tennis in 2nd grid but the moment I do this the filter from 1st grid goes away and it ends up showing me Tennis details for all countries and not for USA as the filter applies only on 1 vizualization.

Do you means the visual highlight filter effect?  If this is a case, current it only works on active visual, so if you click and active on other visual, previous filter effect will be lost.


For your requirement, I'd like to suggest you to create slicers with these specific column which you needed to filter on visuals.

 

BTW, current power bi use 'and' logic to link filter/slicers, you can't direct achieve 'OR'/'NOT' filter on visuals.

 

Regards,

Xiaoxin Sheng