Overlaying Trends from Different Dates - Excelerator BI

Overlaying Trends from Different Dates

In my video today, I continue to build out my Power BI Covid Australia report. I wanted to overlay 2 phases of time on a single chart, as shown below.

There were a few things I needed to do to make this work, including writing some time intelligence to get a 7 day rolling average daily cases. I started to do that with an inbuilt time intelligence function, then swapped to a custom function. As it turns out, I could have kept using the inbuilt version, but I simply didn’t think of the alternative solution at the time (sometimes that is how it happens).

There are a few other tips and tricks in the video too. I hope you get something out of it.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top