Static Filtering while clicking on visual

[alibaba]

Dear Community,

I am looking for a solution to click on a value in a visual and set this selection automatically as a filter that effects all the rest. I know about cross filtering and highlighting. But in general I am looking for a scenario like this:

• I select a product category in a table visual
• I will then jump to another sheet to do further analysis (I do not want to do a drillthrough) or even to stay on the same page with only having data based on the selection
• I will set the selection as a filter that is shown in the filter pane on the right

I know there is some kind of option to right click an then click on include/exclude, but this is only effective for the same visual.

Any ideas?

Thanks a lot and best regards,

Alex

[V-lianl-msft · Accepted solution]

Hi @alibaba ,

There are no feature that fully meet your needs. As you said, drilling is the closest to what you expect.

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

[amitchandak]

@alibaba , for another page you can try drill through to go another page ?

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough