Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get 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 |
|---|---|
| 103 | |
| 80 | |
| 64 | |
| 50 | |
| 45 |