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! Learn more
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()) ))
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.