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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 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 Solution Authors