Forum Discussion
Distinguish between drill up/drill down levels (area chart)
Hello guys,
this is my first post, so let's see how this goes.
I have an area chart.
On the x-axis, there is Year and Month.
On the Month level, I see 2022 & 2023 with 1-12 Months above them. The values are shown for each individual month.
On the Year level, I see only the years 2022 & 2023. The values are shown for each individual year.
There are no slicers.
When the user drills up to Year, I would like to use one calculation.
When the user drills down to Month level, I would like to use another calculation.
Is it in any way possible to distinguish if the user has drilled up to Year level or drilled down to Month level?
If yes, then I can use this distinction wihin a measure, which is exactly what I need to do.
Thank you in advance and a pleasant day!
2 Replies
VijayP thank you for your efforts, Sir.
I tried this one already, but unfortunately it did not help.
You see, both at the Month Level and Year level, the ISFILTERED is FALSE...
Month level:Year level:
.... as long as the user does not click on any of the years or months directly, then it becomes TRUE.
Month level:
Year level:
What I need is a way to destinguish if the user is on the Year level or on the Month level without the user having previously clicked on any point of the area chart.
BR Veljo
