Values to Line Graph

[Anonymous]

I have the below data and I cant figure how to show this as line chart. I am confused I work with lot of data, but in excel its so simple.

But with PowerBi, I am not able to figure out. I have worked with PowerBi, but with a simple data with the below values, I am not able to figure out. 

Month-YY        Max.Temptreture (C )Min. Tempreture ( C)Average Tempreture (C )

Jan-17	28.00	13.00	21.00
Feb-17	30.00	10.00	20.00
Mar-17	37.00	16.00	24.00
Apr-17	42.00	20.00	30.00
May-17	45.00	26.00	33.00
Jun-17	46.00	28.00	35.00
Jul-17	48.00	30.00	38.00
Aug-17	47.00	30.00	37.00
Sep-17	44.00	28.00	34.00
Oct-17	40.00	25.00	31.00

This is the simple kind of graph in Excel, is it possible in PowerBi

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[v-chenwuz-msft]

Hi @Anonymous ,

Here are some articles to help you create line charts

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-line-chart

Using your data you can follow the steps below to create it.

First create a line chart visual

then drag monthe-yy into Axis and three values fields into the Values

If you need to set the characteristics of the line chart, please set it in the format (icon like )

In addition, you can also use Q&A visual to create the charts you want, see the following article

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-q-and-a

Best Regards

Community Support Team _ chenwu zhu

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

[Fowmy]

@Anonymous 

You can use a line graph and add the fields as follows. I attached a file.