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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.

gasilva8_0-1667927863507.png

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

 

2 REPLIES 2
Shaurya
Memorable Member
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 BI 

Anonymous
Not applicable

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.

gasilva8_1-1667943285495.png

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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.