Limit table interactions to only one line in Power BI line chart

[powerbinovice12]

Hello, I need assistance with a challenge in Power BI.

• I have a table that contains rows of various sales items such as books, toys, etc.
• I have a line chart connected to this table that displays three lines representing past closed sales, future closed sales, and possible future sales over several months.
• Currently, when I select a sales item from the table, all three lines in the chart adjust to reflect the sales of that item. However, I want only the "Possible future sales" line to update while the other lines remain unchanged.

Can anyone suggest a solution? Thank you in advance for your help!

[Greg_Deckler]

@powerbinovice12 You would need to adjust your measures in your line chart to accomplish this. You can use ALL in the 2 measures you don't want to change and then filter down to just the filters within the line chart visual that you want to keep. Alternatively you could potentially use REMOVEFILTERS/KEEPFILTERS to accomplish this. Sample data would help me be more specific to model this up. 

[powerbinovice12]

Hi, thank you for your quick reply! I have attached some sample data if that will help. This is what the chart looks like and it is connected to a line chart that has the sales amount of  past closed sales, future closed sales, and possible future sales over several months. 

[powerbinovice12]

@Greg_Deckler 

Data: 

Item Name	Company Name	Revenue	Sell Rate	Date
Cups	Plasticware	1000000	50%	1-Jan-22
Remote Control Car	Fisher Price	233041	43%	1-Jan-22
Blenders	HomeTech Innovations	3824364	45%	1-Jan-22
Tablets	Tech Oasis	3329296	56%	1-Jan-22
Makeup	Beauty Bliss	1932774	39%	1-Jan-22
Bats	Athletic Edge	3031794	65%	1-Jan-22
Gloves	Luxe Threads	1700549	54%	1-Jan-22
Staplers	Write Away	1713253	90%	1-Jan-22
Puzzels	Playful Wonders	2627605	78%	1-Jan-22
Cups	Plasticware	3444762	67%	1-Feb-22
Remote Control Car	Fisher Price	3216086	53%	1-Feb-22
Blenders	HomeTech Innovations	1809216	56%	1-Feb-22
Tablets	Tech Oasis	2025553	77%	1-Feb-22
Makeup	Beauty Bliss	3693491	45%	1-Feb-22
Bats	Athletic Edge	1467846	54%	1-Feb-22
Gloves	Luxe Threads	1149243	34%	1-Feb-22
Staplers	Write Away	3645063	52%	1-Feb-22
Puzzels	Playful Wonders	1548139	34%	1-Feb-22

Measure 1 ( past closed sales): = sum(total revenue)

Measure 2 (future closed sales): =sum(total revenue) 

Measure 3 (possible future sales):  *complex formula 

*they are all in different tables. I apologize for the vagueness, this is a work project. If I can claryify more, please let me know and I will do my best

[Greg_Deckler]

@powerbinovice12 Could you please paste that data as text so I can copy and paste into an Enter Data query? Also, can I get your measure formulas?