Creating Multiday Time Series Graph

[Idntknw]

Hi All,

I have some process measurements which I have recorded hourly and made models for in Azure AI. I would like to create a report which displays actuals and makes use of the Azure models and the first problem I am having with that is the creation of a multi-day time series line chart. Ideally it would have a dropdown/filter for days/weeks/months but thats bonus points for later. Possibly similar to the upper left figure found in this post as I have my data in hourly samples at this stage:

https://community.fabric.microsoft.com/t5/Power-Query/Display-line-graph-in-1-hour-gap-or-interval/t...

My data would natively have a dateime column in the form of dd/mm/yyy hh:mm:ss and i have been unsuccessful in finding/following examples which work for me. I am sure there would be an example on this and i just need to find it/execute it properly so i am wondering if anyone can point me in the right direction. 

Cheers,

[Anonymous]

Hi @Idntknw 

Here are some steps to guide you:

1. Prepare Your Data: Ensure your data is in a format that Power BI can use to create a time series chart. Your datetime column is suitable, but you may need to create additional columns for aggregation if needed.
   
   

2. Import Data into Power BI: Use Power BI’s ‘Get Data’ feature to import your data. You can import data directly from Azure if it’s stored there, or from a CSV file if you’ve exported the data.
   
   

3. Create a Time Series Chart:

   • In Power BI, select the ‘Line chart’ visualization.
   • Drag your datetime column to the ‘Axis’ field.
   • Drag the measurement you want to display (e.g., actuals, forecasted values) to the ‘Values’ field.
   • To aggregate data by hour, you might need to adjust the x-axis to display data in hourly intervals.
     
     

4. Add a Slicer for Time Periods:

   • To create a dropdown/filter for days/weeks/months, use the ‘Slicer’ visualization.
   • Drag your datetime column to the ‘Field’ section of the slicer.
   • In the slicer settings, you can set the type of time intervals you want to allow users to select.
     
     

5. Refine Your Chart:

   • Adjust the formatting options to match the style of the example you provided.
   • You can add features like tooltips, legends, and labels for better clarity.
     
     

6. Publish and Share Your Report: Once your report is ready, you can publish it to the Power BI service and share it with others.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.