The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
Solved! Go to Solution.
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
)
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
)
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |