Combining 3 graphs of the same data into one

[YellaFella]

Ok, so I've managed to show 3 different graphs but wonder if it's possible to have all 3 graphs in one...

I'm jotting down the temperatures across 3 rooms, 3 times a day. Let's say morning, noon and evening. Now in Power BI, I can show the day on the X-axis and dates on the Y-axis per room with the time slot as the legend. I've created a splitter so select the month and then the day and even the time slot for that day. The 3 rooms, let's say living room, kitchen, garage.

At the moment I had to create 3 different graphs to represent the rooms but want to show all 3 graphs in one to make it easier. So they can select the month/day, and the time slot followed by the room choice.

The data from excel has the following columns: date, time (shown as the morning, afternoon, and evening), room 1, room 2, and room 3, the room values are just temperature numbers.

I did look at some solutions about creating a relationship with a DAX created calendar dates but didn't work. Hope someone can help.

[YellaFella]

Thanks amitchandak I'm having a look. I deally I want a line chart rather than a bar graph. Just seen your source files so I'll need to reverse engineer what you did.

Personally it seems the original raw data is wrongly formatted which won't help as its all under one sheet.

[v-yiruan-msft]

Hi @YellaFella ,

In order to provide you a suitable solution, could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[amitchandak]

@YellaFella , Hope those are connected.

You can have both room and type of axis -> Expand axis-> sort on axis and concatenate label off

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

You can use one of them as a legend or Small multiple