Line Graph data point not connecting

[dhuangx5]

Hi, I'm trying to have the orange lind connect. But there seem to be a gap. In excel the work around is to use Connect data points with line, but I can't find that function in powerBI.

[v-yalanwu-msft · Accepted solution]

Hi, @dhuangx5 ;

Your X-axis is Date type or text, if it is date format,you could select continous.

The final output is shown below:

If it not date format. you could add another measure.

Measure = IF([RT]=BLANK(),CALCULATE(AVERAGE('Table (2)'[value]),FILTER(ALLSELECTED('Table (2)'),DATEDIFF([Date],MAX('Table (2)'[Date]),QUARTER) in {-1,1})),[RT])

The final output is shown below:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bishal-raut]

Hi, Thank you for the great solution. My problem is slightly different from this problem. Instead of having missing value on [Value] column I have another column Check which has TRUE/FALSE data. And I have measure which calculation is like this 

Measure = CALCULATE(COUNTROWS('Table'),'Table'[Check]=TRUE())/COUNTROWS('Table')

I have calendar table which has been conected with the date and data is being presented in a weekly manner which means I cannot use continious instead of categorical in X-axis settings. Now, if there is no value which is true within a week I get null value not that my column[Value] is blank but my measure is blank.

Can you help me with the solution or any thoughts would be greatly appriciated. 

[dhuangx5]

Here is the measure I used.

CALCULATE(sum([Actual]),

FILTER(ALLSELECTED('Calendar'[Date]),

ISONORAFTER('Calendar'[Date], Max(Actual[Date]), DESC)))