Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Visual starts at current month instead of current day

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)
Cattura.JPG
I gladly will give kudos,
Thanks 

 

2 REPLIES 2
Anonymous
Not applicable

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

amitchandak
Super User
Super User

@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()) ))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors