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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Yogisda
New Member

Time Series Diagram with two different dates group by days

Hello Power BI Community.

 

I am trying to recreate this diagram in Power Bi

Yogisda_0-1648590153761.png

My data looks like this

Dates TimesCountsSeriesDay
11.11.201903:0033711.11.2019 03:00:00Monday

 

The dates go from 

11.11. – 17.11.2019

and 

09.11. – 15.11.2020

 

And the times go from

00:00-23:00

 

My diagram looks like this right now:

Yogisda_1-1648590346621.png

I would like to have the data from 2020 on top of the data of 2019

So it would look like a comparison of mondays, tuesday, wednesday etc...

The 11.11.2019 is a Monday

the 09.11.2020 is also a Monday

My Diagram is structured this way

Yogisda_2-1648590403131.png

I would be grateful for anykind of help.


Thank you in Advance

Yogisda

 

 

 

1 REPLY 1
Anonymous
Not applicable

Hi @Yogisda ,

 

The default line chart cannot fully restore the format you want.

Put day and time in axis and drill down to the lowest level.

vjaywmsft_0-1648805657139.png

 

Best Regards,

Jay

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Kudoed Authors