Forum Discussion

User12345432334's avatar
User12345432334
Regular Visitor
2 years ago

Finding drill down/up level

Hello.

I have a clustered column chart. For my X-axis, I have 2 columns Week and Day with values like ("2024 W10", "01/01/2024"), and for my Y-axis I have a count of tickets.

The graphic is this:


I added 2 Constant Lines with values 482 and 123 (Thresholds). 

I need to do the following thing: 

if the user is on weekly level, like in the picture above, the thresholds should remain the same, but if the user drills down on daily level, the threshold should be 482 divided by 7 and 123 divided by 7.


Is there a way I can get the level from the graphic in a measure or what are my options to display the threshold dynamically based on drill down/up level?

Thanks in advance!



Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    Hi User12345432334 ,

     

    The constant lines don't have the context of the calendar since they are for the full dates I would add this in the lines of a line and clustered column chart and would create two measures similar to these:

     

    Max Threshold= IF(ISINSCOPE('Calendar'[Date]), 482/7 , 482)

Min Threshold= IF(ISINSCOPE('Calendar'[Date]), 123/7 , 123)

    Now use this measurds on the Line Y-axis and don't forget to align zeros and turn of values of secondary y-axis.