Line graph showing all months in X axis even when data is not present

[Jay2022]

I have a table with dates in one column and %s in another. I'm trying to create a line graph however the line graph is going from November 24 to March 25 etc and i want it to show january february etc even if there is no data for those months (no dates over those periods and no %s) any suggestions ?

[Anonymous]

Hi, @Jay2022 

Have you solved your problem yet? According to @MFelix , you can try the following.

Example data:

Date table:

Date = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Use CALCULATE like

Calculate([Measure], ALL(Dates[Date]))

[Jay2022]

what does ([Measure] relate to ?

[MFelix]

Hi @Jay2022 ,

For this you need to create a calendar dimension table related with your fact table and then on the visualization select the option show values with no data. Be aware that if your line graph has the year and the months it will show for all the values so you need to be carefull with the setup of the chart interactions and filters.