Forum Discussion

Nuno_afonso's avatar
Nuno_afonso
New Member
4 years ago

4 Graphics on the same page from the same table

Hello,

I'm a real newbie on power bi. I need to create 4 graphs from the same table each graph grouped by date.

How can i accomplish this?

Thanks in advance

Table example

2022-05-12FILE A100 GB
2022-05-12FILE B50 GB
2022-05-12FILE C10 GB
2022-05-12FILE D5
2022-05-11FILE A99 GB
2022-05-11FILE B49 GB
2022-05-11FILE C9 GB
2022-05-11FILE D5 GB
2022-05-10FILE A98 GB
2022-05-10FILE B48 GB
2022-05-10FILE C8 GB
2022-05-10FILE D4 GB
2022-05-09FILE A98 GB
2022-05-09FILE B48 GB
2022-05-09FILE C8 GB
2022-05-09FILE D4 GB

2 Replies

  • tackytechtom's avatar
    tackytechtom
    Most Valuable Professional

    Hi Nuno_afonso ,

     

    Are you looking for something like this?

     

     

    I'd do it like this:

     

    1. Split the "Storage" column into a "Unit" and "Value" column. The Value column, I transformed to number type so it'll be easier to create a measure later on. All of the following is done in Power Query:

     

    Under Home, select the "Storage" column, and click on the split column button. Then, choose By delimiter:

     

    Use the following settings:

     

    After, rename the columns by double clicking on the header:

     

    Then, click on "close & apply" button

     

     

    2. Now you can create a graph like this:

     

    X-Axis is Date, Y-Axis is Value and to do the "grouping" I dragged File into the Filter Pane. There, I picked File A for the graph above. After I just copied and pasted the graph and just changed the File Filter. Lastly, I adapted the title for each graph

     

    Note, the Value in the Y-Axis is an implicite measure which in our case is the sum over the values:

     

     

    I'd recommend to create a proper measure though 🙂

     

    Let me know if this helps!

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

    • Nuno_afonso's avatar
      Nuno_afonso
      New Member

      Hello tackytechtom 

      Thank you for the quick answer.

      i would like to group on the same graph by date.

      Group the files on the same date. Something like graph 1 with filea, fileb and filec with first date, graph 2 with filea, fileb and filec with second date and so on.