Forum Discussion
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 thi...
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.