How to filter table visual with Line selection in Power BI

[Anonymous]

Hi Everyone,

I have below chart and a table visual. I need to filter the table data by selecting the line data points. For example, if I select Jun 2022 data point, it should only give me selected incidents. But, when I select the line, it is also showing me Observations along with Incident records for Jun 2022 in the table. Is there any way, I can only show the Incident (line selection) in the table not the Observations?

Thanks in advance!

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

According to your description, add relevant fields to the filter based on the fields in the x-axis. When selecting a specific date and the corresponding event data record (specific date).

If I misunderstand you, can you provide a screenshot of the desired result and describe it, so that I can answer it for you as soon as possible. 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.

[lbendlin]

Add a filter to your table visual that hides all observations.

[Anonymous]

@lbendlin That will not help coz I need to show observations when any bar item is selected. I want it to be dynamic. It should only show Incidents (for particular month) when line is selected and observations when bar is selected.

[lbendlin]

You are trying to cram too many dimensions/glyphs into a single visual. Use separate visuals.