Forum Discussion

jblackburnHWGA's avatar
jblackburnHWGA
Helper I
5 years ago
Solved

line chart help

I need a bit of help plotting a line graph. Not sure its how i have my data or how i'm using the graph settings

 

I have 10 sites with finance data over 5 years for each site.

I want to plot the year over the x axis. Each site is a line on the graph. Y is the value. We can then see growth over time or not growth over time.

Excel looks like

 

site18/1919/2020/21
14564655677688990
24353456756780978
36563456767470077
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, jblackburnHWGA 

    According to your description and sample data, I think you can use the “Unpiovit columns” operation in the Power Query to get the correct data model to achieve your requirement, you can try my steps:

    1. Go to the Power Query and click like this:

     

    Then you can get the correct data model like this:

     

    1. Click on “Close and apply” and create a line chart and place it like this:

     

    You can also create a slicer for the [Site] to slice the chart by site id, like this:

     

    And you can get what you want.

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

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

5 Replies

  • lance_6's avatar
    lance_6
    Helper II
    5 years ago

    You need to structure your data differently to work with that scenario. 
    Here is the best way for that: 

     

     

     

     

     

     

     

     

     Then put the data in your line chart feilds as follows: 

    Axis : `Date`

    Legend : `Site`

    Values : `Value`

  • v-robertq-msft's avatar
    v-robertq-msft
    Community Support
    5 years ago

    Hi, jblackburnHWGA 

    According to your description and sample data, I think you can use the “Unpiovit columns” operation in the Power Query to get the correct data model to achieve your requirement, you can try my steps:

    1. Go to the Power Query and click like this:

     

    Then you can get the correct data model like this:

     

    1. Click on “Close and apply” and create a line chart and place it like this:

     

    You can also create a slicer for the [Site] to slice the chart by site id, like this:

     

    And you can get what you want.

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

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