Independent slicers on each line in line chart

[wsuphappyhour]

Hi,

I need help or answer how to achieve this simple goal:

I have 1 simple data table(applies to both line charts)

I have 2 line charts and 2 sets of  slicers(same for both charts)

Ecah line chart consists of 1 static line (same on both(exact values, column))

And one line cotrolled by slicers(same on both(exact values, column))

Question:

How to merge these line charts to get 2 dynamic lines controled by 2 sets of slicers.

Goal: to compare same data set with different selections on 1 chart

I am new to PBI i know how to do it with pivot table in excel but not here..

 View when slicers applied(goal to get both lines on 1 chart..):

[v-shex-msft · Accepted solution]

HI @wsuphappyhour,

If you want line chart shows different values by two slicers, you need to create a new table as source of one slicer. (It is impossible to use same table as source of two slicers to filter on same column)

Sample:

AVG measure is static value which not effect by slicers.
Red line controlled by table 2 'weekday'; another line controlled by current date column.

Formula:

AVG = 
AVERAGEX ( ALL ( 'Table' ), [Amount] )

Dynamic =
CALCULATE (
    SUM ( 'Table'[Amount] ),
    FILTER (
        'Table',
        'Table'[Date]
            IN CALCULATETABLE ( VALUES ( 'Table 2'[Date] ), ALLSELECTED ( 'Table 2' ) )
    )
)

Notice: these tables not have relationship.

Regards,

Xiaoxin Sheng

[wsuphappyhour]

Great it works! I thought that I am over complicating things 🙂 Thanks Again