Remove blank spaces from a Line Chart visualization

[ManuSacchetti]

Hello Community,

I need help with a Line Chart visualization. I want the blank spaces to be filled with a line in case the table does not have any data. This is the visualization that I´m getting right now:

The DAX expression I´m using right now is YTD Vehicles Deployed = TOTALYTD(COUNT('Data Dashboard'[TIPO DE UNIDAD]),'Calendar'[Date]).

Can you help me please? Thank you 🙂

[v-stephen-msft]

Hi @ManuSacchetti ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.

Best Regards,
Stephen Tao

[amitchandak · Accepted solution]

@ManuSacchetti , Make sure the calendar table is marked as date table and column on the axis, Month name and week of year are coming from date table