How to prevent a line chart from showing months with no data

[Josevolquez85]

Hello community, I hope you are very well. As I show in the following image, I have a data model, with a column "datetime" and another that shows temperature values "TEMP1-BONAL":

As shown in the bar chart in 2022 there is no data for several months such as January and April. On the line chart, however, lines are shown for the months of January and April. I tried filtering the "datetime" column so it doesn't show blank values, but it didn't work:

When I plot the temperature against an index column, it no longer shows the straight lines as on the graph in the first image:

 What is the mistake?

Thanks for the support.

[TheoC]

Hi @Josevolquez85, if the post I provided solves your issue, can you kindly accept is as the solution to allow other Community members to search for it if they experience the same challenge. 

Thanks heaps in advance.

Theo

[Josevolquez85]

Thank you TheoC,

Despite using the categorical option, I can't see all the data in the graph without having to scroll.

I need solve this to close the issue, please.

[TheoC]

@Josevolquez85 your X Axis should be using the Calendar table as the basis.  Currently, you're using it from your Data table.  From here, switch the settings back to CONTINUOUS instead of CATEGORICAL. 

Let us know how that goes.

Thanks,

Theo 🙂

[TheoC]

Hi @Josevolquez85 

The issue you're experiencing is because the X-Axis is set to "Continuous" rather than Categorical.  

Change it to Categorical and this will correct the issue.

The context of the above is because fields or columns that are DateTime or Date or Time can be "continuous."  Power BI offers the ability to have these fields represented as "Continous" (i.e. uninterrupted) or on a "Categorical" basis (i.e. whatever exists in the data).

Hope this helps.

Theo 🙂