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
Hi all,
I have this one visual that represents some data on a timeline (x-axis) and I want it to show every date, even the ones in which there is no data to show.
The problem is, when I select "show every element" it shows every month of the current year so, given that I need it to start from today instead of january 1st I fixed this problem by selecting which months I want to see data for by a multiple selection filter, but it is a very non elegant solution and my visual is kinda ugly because it starts from semptember 1st.
How do I get it to start from today and dynamically update itself (right now it doesn't because of the multiple selection filter)?
My datetable consists of a calendarauto(today(), today()+365)
I gladly will give kudos,
Thanks
Hi @Anonymous,
I'd like to suggest you use measure expression to replace raw value field and add if statement to check current value to replace the not existed part to 0 instead of blank. (power bi will auto-hide these blank parts on your chart)
If you are confused about the coding formula, please share some dummy data and expected results to test:
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
@Anonymous , This year calendar
calendar(date(year(today()),1,1) , date(year(today()),12,31))
Or measure this year today
YTD=
CALCULATE(sum('Table'[Qty]), FILTER(('Date'),'Date'[Year] =year(Today()) ))
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!