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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.