Time Series Chart in Power BI

Question

How can I plot a value over a time series in the Power BI Report Builder? My data is acquired from a relational MSSQL database. Now, this value (unit capacity) has a StartDate and an End Date. So I've created a date-time dimension inside Power BI using an mquery to replicate the days between 2 selected years. Can anyone tell me how should I plot the Unit capacities over a time series chart? Then I created filters so that I can choose which Refinery unit to plot.

So my way to tackle it is by creating a relationship between the IIROutagesDenormalised and DateTimeDim over the handle where the handle is in this format: {YYYY}-{MM}-{DD}. Is this the right way to do this?

When I tried to Create the DAX query to get the Calendar date dimension, this is giving me the error below:

Answer 1

Your Date format should be handled by Power BI. You need not worry about it as long as the data type is correct. Not so sure about the business logic but I think you'd find simpler way using DAX.

Create a calendar table using DAX:

It shall return a table with column Date.

Then, create a relationship between the Date column and OutageStartDate.

You can use this measure (Feel free to make alterations depending upon business logic).

You can plot something like the following.