Forum Discussion
Power BI Interaction Issue Between Table and Line Chart
I have a table visual at the top and a line chart below it in Power BI.
When a user selects a row in the table, the line chart correctly filters and shows the corresponding row-level data.
However, if the user then selects a data point on the line chart, the table selection gets cleared. As a result, the chart switches to showing total or average values, and the previously displayed row-level line disappears.
Requirement:
I want the table selection to remain persistent, and the line chart should continue to display data based only on the selected row(s) from the table, even if the user interacts with the chart.
Has anyone faced this behavior? How can I prevent the chart interaction from overriding or clearing the table selection?
First screen
After clicking any data point
Hi svssatish,
Currently there's no native way to keep a table row permanently selected while continuing to interact with another visual.
Workaround is to use a slicer instead of table row selection, as slicer selections persist while interacting with other visuals. Configure Edit Interactions so the line chart does not affect the table.
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer
9 Replies
- Rupa01
Solution Sage
Hi svssatish,
If you want the table selection to remain persistent, you will need to adjust the visual interactions between the table and the chart -
Go to Format > Edit interactions while the table is selected.
On the line chart, change the interaction from 'filter' to 'none'. This way, clicking on the chart will not override the table’s filter context.
The chart will continue to respond only to the table selection, and user clicks on the chart will not clear it.
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer Hi Rupa,
Thanks for your response. However, if I set the interaction to 'None', the chart no longer responds to the table selection at all, so the requirement is not fulfilled.
My requirement is for the chart to be filtered by the table selection, but at the same time, interactions on the chart should not override or clear the table selection.
- Rupa01
svssatish Currently, we don't have option available in Power BI to keep the data point selected to be fixed while interacting with another visual data point.
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer
- Shahid12523
Community Champion
When you click a data point in the line chart, it creates a new filter context and clears the table selection. Unfortunately, there is no built-in way to keep a table selection fixed while using another visual. For lasting filtering, use a Slicer instead of a table, or turn off the chart's interaction with the table using Edit Interactions
v-karpurapudCommunity Support
Hi svssatish
Thank you for submitting your question to the Microsoft Fabric Community Forum. Thanks also to Rupa01 and Shahid12523 for providing helpful suggestions.
I hope the information shared helps resolve your issue. If you have more questions or need further assistance, please let us know. We're here to help.
Best regards,
Community Support Team.- MattKav
Advocate I
Yes this is expected functionality - I tell my users if they want to select data points from multiple visuals, hold CTL when clicking on subsequent data points.
Do we have workaround for this issue.?
- Rupa01
Hi svssatish,
Currently there's no native way to keep a table row permanently selected while continuing to interact with another visual.
Workaround is to use a slicer instead of table row selection, as slicer selections persist while interacting with other visuals. Configure Edit Interactions so the line chart does not affect the table.
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer
- v-karpurapud
Hi svssatish
We were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank You.
