Time Series Chart in Power BI

0 votes

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:

Nov 26, 2018 in Power BI by Shubham
• 12,270 points
452 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

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.

answered Nov 26, 2018 by Upasana
• 7,680 points

Related Questions In Power BI

0 votes
1 answer

Chart with only some values in field in a graph in power BI?

Hi Banu, While creating a chart, put the ...READ MORE

answered Apr 10 in Power BI by CHERUKURI
• 13,940 points
6 views
0 votes
1 answer

Programmatically sign in - power bi

Basically: POST request to: https://login.microsoftonline.com/common/oauth2/token Body, form-url-encoded: grant_type: "password" scope: "openid" resource: "https://analysis.windows.net/powerbi/api" client_id: ...READ MORE

answered Sep 19, 2018 in Power BI by Kalgi
• 35,800 points
36 views
0 votes
1 answer

create interactive R plots in Power BI

 Right now Power BI only supports render ...READ MORE

answered Sep 20, 2018 in Power BI by Kalgi
• 35,800 points
24 views
0 votes
1 answer

How many reports can be created in one Power BI reports

You have a limit of 1000 datasets ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 14,080 points
20 views
0 votes
1 answer

Calculate Time Intersection to Correlate Sequences of Independent Events

I think this solution requires a CROSS JOIN implementation. ...READ MORE

answered Oct 26, 2018 in Power BI by Upasana
• 7,680 points
32 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,100 points

edited Oct 11, 2018 by Kalgi 85 views
0 votes
1 answer

Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 35,800 points
42 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered 4 days ago in Power BI by VNK
3,721 views
0 votes
1 answer

How can i see my plugin name in the Power BI Visual plugin List ?

there is a couple of errors in your ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 7,680 points
31 views
0 votes
1 answer

Error:connecting to Azure SSAS server in Power-BI through Import mode

If I understand correctly, you're connecting to ...READ MORE

answered Nov 9, 2018 in Power BI by Upasana
• 7,680 points
120 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.