4 Graphics on the same page from the same table

[Nuno_afonso]

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-12	FILE A	100 GB
2022-05-12	FILE B	50 GB
2022-05-12	FILE C	10 GB
2022-05-12	FILE D	5
2022-05-11	FILE A	99 GB
2022-05-11	FILE B	49 GB
2022-05-11	FILE C	9 GB
2022-05-11	FILE D	5 GB
2022-05-10	FILE A	98 GB
2022-05-10	FILE B	48 GB
2022-05-10	FILE C	8 GB
2022-05-10	FILE D	4 GB

2022-05-09	FILE A	98 GB
2022-05-09	FILE B	48 GB
2022-05-09	FILE C	8 GB
2022-05-09	FILE D	4 GB

[tackytechtom]

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]

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.