Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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!
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |