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/2019 16/01...
Need Help
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