Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Need something like this

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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