Forum Discussion
Measure Not Working on Line Chart Y-Axis Maximum
Hi Power BI Experts, I could use some help with a DAX and visual interaction issue:
I'm trying to create a dynamic Y-axis maximum for a line chart that responds to different levels of date granularity. Here's the measure I created:
The intention is to return a different maximum value based on the current date level selected via bookmark navigation (week, month, or year).
When I use this measure in a matrix visual, it works perfectly—returning the expected values when switching between date levels using the bookmark navigator.
However, when I try to apply this same measure to the Y-axis Maximum range via Conditional Formatting on a line chart, it doesn’t respond at all. The value remains static, regardless of which date granularity is selected.
Is there any workaround to get this formula to work?
Below is the link to my power BI report :
https://drive.google.com/file/d/1PNr_YBySL6FxNSUZMji1lqB23oLzjJw4/view?usp=sharing
Appreciate any insights!
Hi,
I am not sure if I understood your question correctly, but one of ways to achieve this is to use field parameter feature.
Use report readers to change visuals (preview) - Power BI | Microsoft Learn
Please check the below picture and the attached pbix file whether it suits your requirement.
Y-Axis Max limit: = SWITCH ( SELECTEDVALUE ( prm_x_axis[title_sort] ), 0, 10, 1, 20, 2, 30 )
2 Replies
- Jihwan_Kim
Super User
Hi,
I am not sure if I understood your question correctly, but one of ways to achieve this is to use field parameter feature.
Use report readers to change visuals (preview) - Power BI | Microsoft Learn
Please check the below picture and the attached pbix file whether it suits your requirement.
Y-Axis Max limit: = SWITCH ( SELECTEDVALUE ( prm_x_axis[title_sort] ), 0, 10, 1, 20, 2, 30 ) OMG thanks Jihwan_Kim , it workkkksssss.
Thank you so so much!
