Mixed Daily and Intra Day Chart

[gasilva8]

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:00	10
11/06/2022 12:00:00	20
11/07/2022 00:00:00	50
11/07/2022 12:00:00	25
11/08/2022 00:00:00	80
11/08/2022 12:00:00	65
11/08/2022 00:00:00	90
11/09/2022 12:00:00	20

[Shaurya]

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 

[gasilva8]

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!