topic Selected item applied as filter in Developer

Selected item applied as filter

nixjavi — Tue, 21 Sep 2021 13:13:58 GMT

Hello team,

I am currently developing a report where it is critical to allow the user that when selecting an item within a table, this item is applied as a filter (the idea is to propagate this filter throughout the report).

For example:

Report

Action:

This type of functionality is available in systems such as Qlikview for example, so we would like to be able to offer the end user the same functionality.

Re: Selected item applied as filter

lbendlin — Wed, 22 Sep 2021 01:11:09 GMT

Change the default interaction from cross highlighting to cross filtering.

Re: Selected item applied as filter

V-lianl-msft — Fri, 24 Sep 2021 07:05:21 GMT

Please try sync slicer:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicers-on-other-pages

Re: Selected item applied as filter

nixjavi — Mon, 27 Sep 2021 07:30:40 GMT

Thanks for the information, but my report is using sync slicers between the pages. What I'm asking for is a way to define a filter when I click an item in a table. For example, if I chose a date on the table in my picture, that date becomes a filter on the top.

Re: Selected item applied as filter

nixjavi — Mon, 27 Sep 2021 07:31:23 GMT

Thanks for the information, but same situation. I want to define a filter based on the selection in a table with no extra click.

Re: Selected item applied as filter

lbendlin — Mon, 27 Sep 2021 10:50:10 GMT

This is Power BI, not QlikSense. Teach your users how to operate the filter panel.

Re: Selected item applied as filter

nixjavi — Wed, 29 Sep 2021 12:58:29 GMT

Thanks for your time