Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
powerbinovice12
Regular Visitor

Filter only one value or line in a multi-line line chart in Power BI

Hello,

I am currently working with a table visualization that displays sales data, which is connected to a line chart consisting of three lines. Upon selecting a row in the table, the three lines on the line chart automatically adjust to the selection. Additionally, there are other filters available on the dashboard. I am exploring the possibility of modifying the selection behavior so that when a row in the table is selected, only two of the lines will move while the third remains stationary, while still allowing all three lines to adjust when using the filters on the dashboard. Please let me know of you have any suggestions - thank you! 

1 REPLY 1
amitchandak
Super User
Super User

@powerbinovice12 , You have try the other two lines using a measure which removefilters on few columsn

 

calculate([Measure2], removefilter(Table1[col], Table[col2]))

 

or refer

Power BI Partial Interactions, Selectively pass filter across visuals - https://youtu.be/SFEKQEic_sk

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.