cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Izzywei Frequent Visitor
Frequent Visitor

Building a discontinuous chart with period data

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/201916/01/201949
2/02/20199/02/201948
10/02/201917/02/201948

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

 

Thx

Izzy

3 REPLIES 3
Izzywei Frequent Visitor
Frequent Visitor

Re: Building a discontinuous chart with period data

Untitled.png

Need something like this

Community Support Team
Community Support Team

Re: Building a discontinuous chart with period data

@Izzywei ,

 

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
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Izzywei Frequent Visitor
Frequent Visitor

Re: Building a discontinuous chart with period data

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