Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
User12345432334
Regular Visitor

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:

User12345432334_0-1721723362878.png


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.

User12345432334_1-1721723469891.png


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!



1 REPLY 1
MFelix
Super User
Super User

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.

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.