Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Parameters - Graph two series in a chart following the same parameter

Hi, i want to display in a chart the weekly evolution of two measures:

Q Service Suscriptions =
COUNT('Suscriptions and Unsuscriptions'[Identifier])

Q Service Unsuscriptions =
COUNT('Suscriptions and Unsuscriptions'[UnsuscriptionDate])

I want to display this two series in a line chart with the possibility of selecting two visions:
.Weekly Total

.Cumulative Total

 

For the cumulative total I ´ve created another measure:

Cumulative suscriptions =

CALCULATE(
[Q Service Suscriptions],
FILTER(
ALL('Suscriptions and Unsuscriptions'),
'Suscriptions and Unsuscriptions'[SuscriptionDate] <= MAX('Suscriptions and Unsuscriptions'[SuscriptionDate])
         )

)

 

I want to create a parameter to select between the weekly total and the cumulative total, but

I don´t know how to create a single parameter to show the two series.

 

Thank you so much!

 

1 Reply