Forum Discussion
Line Graph data point not connecting
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.
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.
3 Replies
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.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.
Here is the measure I used.
CALCULATE(sum([Actual]),
FILTER(ALLSELECTED('Calendar'[Date]),
ISONORAFTER('Calendar'[Date], Max(Actual[Date]), DESC)))
