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
I want to display it like different discontinuous lines in a chart.
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
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.