Filter radar chart data by two separated filters

[Fátima]

Hi!

I have a radar chart where I would like to show a comparison in time of the registers I have on a dataset. The expected output would be similar to this:

Is there a way where I can have the blue and the yellow area show the same column, but filtered by different dates? Right now I have on the Y axis the same column added twice, they are both overlapping on the blue area, and if I change the filter it affects both the same way. The idea is, for example, that the blue area shows the results taking into consideration all the rows of the dataset and the yellow one just the ones filtered to a determined date.

Thanks in advance, regards!

[JorgePinho]

Hello @Fátima !

Create a measure that calculates the value based on a Date. Then add the measure to "Eje y" 🙂

[Fátima]

Hi @JorgePinho !

But will I be able to filter the date the measure is based on? The dates it takes need to be dynamic, so the user can change them, and both areas need to be filtered separately.

Regards!

[JorgePinho]

If you want both of the measures with different dynamic dates you need to have two calendar tables.