Results 1 to 2 of 2

Thread: Ploting of Graph IN PowerBI with different values and different Year
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Ploting of Graph IN PowerBI with different values and different Year

    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:

    https://drive.google.com/open?id=1Qr..._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:

    https://drive.google.com/open?id=1kA...WbIid3usFJGZ-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:

    https://drive.google.com/open?id=1d9...b3-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

  2. #2
    New Member
    Join Date
    Jul 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Ploting of Graph IN PowerBI with different values and different Year

    Just to make things clearer:
    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.

    Prefereably as i have in pivot chart too , a filter for Month.
    Thanks Lots
    Quote Originally Posted by SkyandSea View Post
    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:

    https://drive.google.com/open?id=1Qr..._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:

    https://drive.google.com/open?id=1kA...WbIid3usFJGZ-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:

    https://drive.google.com/open?id=1d9...b3-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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •