Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
site | 18/19 | 19/20 | 20/21 |
1 | 456465 | 56776 | 88990 |
2 | 435345 | 67567 | 80978 |
3 | 656345 | 67674 | 70077 |
Solved! Go to Solution.
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:
Then you can get the correct data model 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.
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:
Then you can get the correct data model 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.
Yes all working. Many thanks
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`
Did this work for you?
my table didn't come out well lol hope you get the idea
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
78 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
83 | |
70 |