Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
v-chuncz-msft
Community Support
Community Support

@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
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.
Anonymous
Not applicable

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
Not applicable

Untitled.png

Need something like this

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.