Forum Discussion

Jay2022's avatar
Jay2022
Icon for Helper IV rankHelper IV
1 year ago

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

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 ?

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Use CALCULATE like

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.