Slicer

[colourfullife]

Hi All,

I need your help.

I want to make slicer to filter each lines that created indivisually in the graph.

this is my graph.

for stick graph, i used this dax :

1. CBT Issurance = CALCULATE(COUNT('Data - CSU SP'[CBT issuance date]),USERELATIONSHIP('Data - CSU SP'[CBT issuance date],'calendar'[Date]))

for line graph i used : 

CBT Issurance = IF("CBT Issurance" in values('SP Filter'[SP Filter]),

CALCULATE(

    COUNTA('Data - CSU SP'[CBT issuance date]),USERELATIONSHIP('Data - CSU SP'[CBT issuance date],'calendar'[Date]),

    FILTER(

        ALLSELECTED('calendar'[Date]),

        ISONORAFTER('calendar'[Date], MAX('calendar'[Date]), DESC)

    )

))

i created one slicer but it only filter line graph.

can i make a new slicer which can filter stick and line at the some time?

what i want is when i filter CBT issurance, then CBT data up on graph.

now all sticks are up on. 

if the question is not clear, please let me know.

thanks,

CL

[V-pazhen-msft]

@colourfullife 

Can you share a sample pbix so I can test out?

Regards