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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello,
I'm having a problem displaying my data.
What I want is to show the X axis from today to the date with last value from another table. What I have is an overflow of dates as this (red line indicating where I want X axis to stop).
Additionally, my data model looks like this
[Date]1---*[valuetable]
And my measure like this:
Solved! Go to Solution.
Hi @Anonymous ,
Change Categorical to Continuous:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please create a flag measure:
Measure =
var _maxdate=MAXX(ALL('Date'),[Date])
return
IF(MAX('valuetable'[Date])>=TODAY()&& MAX('valuetable'[Date])<=_maxdate,1,0)
And drag it to filter pane, set as "is 1":
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi!
This almost worked for me. Is there an easy alternation here so I can display blank dates as well? This measure does cut the date to last date of valuetable but it also erases empty values from X axis.
Measure =
SUMX(
SUMMARIZE(
FILTER(
'Table',
'Table'[Date]<TODAY()
),
'Table'[Date],
"@sum",SUM('Table'[Amount])
),
[@sum]
)
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.