Forum Discussion

dhuangx5's avatar
dhuangx5
Frequent Visitor
4 years ago
Solved

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.   ...
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

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's avatar
    bishal-raut
    Regular Visitor
    3 years ago

    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.