Forum Discussion
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: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 |
2 Replies
- Shaurya
Memorable Member
Hi Anonymous,
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 BIHello 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!
