Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Mixed Daily and Intra Day Chart

Is it possible to get this result using some measure or visual? Daily and intra day at the same chart.


I found the example above here:

Mixed Daily and Intra-Day Chart - amCharts

My table has the structure below. What should I do to get the same result?

Datetime                             Value        
11/06/2022 00:00:0010
11/06/2022 12:00:0020
11/07/2022 00:00:0050
11/07/2022 12:00:0025
11/08/2022 00:00:0080
11/08/2022 12:00:0065
11/08/2022 00:00:0090
11/09/2022 12:00:0020


Memorable Member
Memorable Member

Hi @gasilva8,


You can use a Line and Clustered Column Chart. Alternatively, you can also try getting a custom visual, ZoomCharts Drill Down Combo.


Works for you? Mark this post as a solution if it does!
Check out this post of mine: Forecast Period - Previous Forecasts 
Spare some time to read: How to Export Telemetry Data from Azure IoT Central into Power BI 

Hello @Shaurya 

I already tried the Line and Clustered Column Chart, but didn't get the same result (second chart on the image below).

The first chart is the result of overlapping a Line chart and a Column Chart visuals. That is what I need.


The column should show total value per day and line should show value at diffferent times along the day.

Basically I need X-axis to show Date (for day) and Datetime (for intraday) values, and this doesn't happen with that visual.

I will take a look on ZoomCharts Drill Down Combo visual and return to tell the result.

Thank you!




Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors