How to get a Continuous Line Graph for all Dates - if you are Missing Values for some Dates?

[Ahmedx · Accepted solution]

pls try this

[Ahmedx · Accepted solution]

pls try this

[Anonymous]

.

[v-tangjie-msft · Accepted solution]

Hi @Anonymous ,

This is due to the design of this visual object.
If you want to have consecutive dates. create the following measure that fills the value of a null-valued date with 0. at which point the curve is:

Measure = SUM('Table'[MTBF])+0

Best Regards,

Neeko Tang

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

[v-tangjie-msft]

Hi @Anonymous ,

I can't access your pbix file, please change the permissions and reshare the link.

To have a continuous date series, you can add a Date table. A simple method is to use DAX function Calendar. Then build a relationship between Date table and Fact table on Date column. Use Date table's Date column on X-axis of the line chart. This could make the X-axis have all continuous dates. And on the dates that are missing in Fact table, the measures with "+ 0" will return 0.

DateTable = CALENDAR(MIN(YourDataSource[DateColumn]), MAX(YourDataSource[DateColumn]))

Value Measure = SUM ( 'Table'[value] ) + 0

Best Regards,

Neeko Tang

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

[Anonymous]

.