Building a discontinuous chart with period data

[Anonymous]

Hi all, 

I am new in PowerBi and now need your help!

I have some data with startdate and enddate, how can I display it with period?

startdate          enddate         usage

9/01/2019	16/01/2019	49
2/02/2019	9/02/2019	48
10/02/2019	17/02/2019	48

I want to display it like different discontinuous lines in a chart.

Thx

Izzy

[v-chuncz-msft]

@Anonymous ,

Drag date from a calendar table and add measure below.

Measure =
VAR d =
    SELECTEDVALUE ( 'Calendar'[Date] )
RETURN
    SUMX (
        FILTER ( Table1, Table1[startdate] <= d && Table1[enddate] >= d ),
        Table1[usage]
    ) + 0

[Anonymous]

Hi @v-chuncz-msft ,

Thank you for your reply, but I think thats not the solution I excepted. If there are 0 in the graph and there will be an increase from 0 to 48. 

What I want to build is a discontinuous chart which are isolated.

Thanks,

Izzy

[Anonymous]

Need something like this