Forum Discussion
Values to Line Graph
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
3 Replies
- Fowmy
Super User
Anonymous
You can use a line graph and add the fields as follows. I attached a file. - v-chenwuz-msft
Community Support
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.
- Ashish_Mathur
