Ploting of Graph IN PowerBI with different values and different Year

SkyandSea

New Member
Joined
Jul 12, 2019
Messages
2
Hi all,

Hi all,
Pretty to power BI charting and eager to learn and be involved in the community =)
First i will show what i did previously using powerquerry and pivot chart in excel 2016 and then i show where i am stuck in powerBI
Basically i have a simple table querry from SQL:
open

https://drive.google.com/open?id=1Qr-AdHMmBCBx4ZsuSw_YEKOWzz7hU6hM
Then after , using a pivottable i put the year and values in columns in pivottable field and the pivot chart shows what i want:
open

https://drive.google.com/open?id=1kAk_p8agZKAeI5DUbbWbIid3usFJGZ-P
*ignore the 2nd Y axis (bar chart) for the moment.

Using Get data in powerBI i querry the same table and i am able to get:
open

https://drive.google.com/open?id=1d9Fs_JrBUXw9kWpFvjb3-59KK0JR4-7F

I am able to get the a chart of the Average Price, Min Price, Max Price vs Day or Average price of 2017, 2018, 2019 vs Day but i like to have all 9 lines in the same chart ( as per excel)
I have been trying this for the past few hours but i cant seem to figure it out weather its by column hierachy etc. I have transform the Date into seperate 3 columns to be year, Month, Date so i could avoid the Date Hierachy but it doesnt work as well.

PS: Fecha is Date and Precio is Price. I do not need the Moving average as seen in my excel example for now but it would be good to have too.

Regards
Ang
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Just to make things clearer:
[FONT=&quot]Bascially with my source table below (4 columns sourcedata of Date, Price Min, Price Average, Price Max) ,
i like to plot Price vs Month/Day with 9 series of 2017Min, 2017Avg, 2017Max, 2018Min, 2018Avg, 2018Max, 2019Min, 2019Avg, 2019Max.[/FONT]

[FONT=&quot]Prefereably as i have in pivot chart too , a filter for Month.
[/FONT]
Thanks Lots
Hi all,

Hi all,
Pretty to power BI charting and eager to learn and be involved in the community =)
First i will show what i did previously using powerquerry and pivot chart in excel 2016 and then i show where i am stuck in powerBI
Basically i have a simple table querry from SQL:
open

https://drive.google.com/open?id=1Qr-AdHMmBCBx4ZsuSw_YEKOWzz7hU6hM
Then after , using a pivottable i put the year and values in columns in pivottable field and the pivot chart shows what i want:
open

https://drive.google.com/open?id=1kAk_p8agZKAeI5DUbbWbIid3usFJGZ-P
*ignore the 2nd Y axis (bar chart) for the moment.

Using Get data in powerBI i querry the same table and i am able to get:
open

https://drive.google.com/open?id=1d9Fs_JrBUXw9kWpFvjb3-59KK0JR4-7F

I am able to get the a chart of the Average Price, Min Price, Max Price vs Day or Average price of 2017, 2018, 2019 vs Day but i like to have all 9 lines in the same chart ( as per excel)
I have been trying this for the past few hours but i cant seem to figure it out weather its by column hierachy etc. I have transform the Date into seperate 3 columns to be year, Month, Date so i could avoid the Date Hierachy but it doesnt work as well.

PS: Fecha is Date and Precio is Price. I do not need the Moving average as seen in my excel example for now but it would be good to have too.

Regards
Ang
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,176
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top