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.

dhuangx5's avatar
dhuangx5
Frequent Visitor
4 years ago

Here is the measure I used.

 

CALCULATE(sum([Actual]),

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

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