Line and Clustered chart to show unselected value in bar and selected value in line for comparison

[Anonymous]

Line and Clustered chart to show unselected value in bar and selected value in line for comparison:

Could you help me options to acheive this expected result apart from adding multiple visuals. 

Slicer:

Table Data:

Expected output:

Show selected value in line and unselected value in bar. This is to compare value of selected value against all other values.

[parry2k · Accepted solution]

@Anonymous here is what you need to do

Add new data table for slicer, go to modelling table, new table and enter following expression

Slicer = VALUES( Test[X Axis] )

Create a slicer and use X-Axis column from above new table

now add two measures, one for bar and one for line

Bar Value = 
VAR __selectedXAxis = SELECTEDVALUE( Slicer[X Axis] )
RETURN
CALCULATE( SUM( Test[Y Axis] ), KEEPFILTERS( Test[X Axis] <> __selectedXAxis ) )

Line Value = 
VAR __selectedXAxis = SELECTEDVALUE( Slicer[X Axis] )
RETURN
CALCULATE( SUM( Test[Y Axis] ),  Test[X Axis] =  __selectedXAxis ) * DIVIDE( [Bar Value], [Bar Value] )

here is what you get if ID 2  is selected