Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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 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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |