Associate
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 one of the rooms on the Y-axis. 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. Can anyone help out with this?
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'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 one of the rooms on the Y-axis. 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. Can anyone help out with this?
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.
Last edited: