Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have this dashboard and I want both my Y axis aligned. I tried creating a "Max_Value" metric and set it as maximum Y limit for both axis, but this metric does not respect my TimeFilter (it shows the Yearly max even when I select monthly). How can i solve this?
Here is the link to my sample dashboard.
https://drive.google.com/file/d/15Cqmf9xnsXuhpiufceEjrkNCtrBM3H1q/view?usp=sharing
Solved! Go to Solution.
Since you have 'calendar'[dt_date] on the X-axis, you need to find the maximum of the two measures per dt_date.
To do this, update Max_Value as follows:
Max_Value =
MAXX (
VALUES ( 'calendar'[dt_date] ),
MAX ( [_TotalExpenses], [_TotalSales] )
)
The original Max_Value measure returned the maximum of the totals of the two measures, which didn't change when TimeFilter changed.
Does this work for you?
Regards
Since you have 'calendar'[dt_date] on the X-axis, you need to find the maximum of the two measures per dt_date.
To do this, update Max_Value as follows:
Max_Value =
MAXX (
VALUES ( 'calendar'[dt_date] ),
MAX ( [_TotalExpenses], [_TotalSales] )
)
The original Max_Value measure returned the maximum of the totals of the two measures, which didn't change when TimeFilter changed.
Does this work for you?
Regards
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 73 | |
| 50 | |
| 48 | |
| 45 |