Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi community,
I'm totally new in Power BI, so this may be a question with a simple answer.
Suppose I have 3 tables:
- Teachers (Id, Name)
- Rooms (Id, Name)
- Reservations (TeacherId, RoomId, reservation date)
Quite simple, a teacher can make a reservation for a room, so one teacher has many rooms, and one room has many teachers.
If a reservation is made, it creates a record in the reservation table.
What I want is a visualization of ALL teacher (as rows) with ALL rooms (as columns), and an indication whether there was a reservation (just a checkmark or the reservation date).
RoomName 1 | RoomName 2 | RoomName 3 | RoomName 4 | RoomName 5 | |
TeacherName 1 | x | x | |||
TeacherName 2 | x | ||||
TeacherName 3 | x | x |
should I use a matrix for this, or... ?
Thank you all for your help.
Solved! Go to Solution.
Hi @JoLambrichts,
Please create relationship between Teachers and Reservations(one to many), Rooms and Reservations(one to many), then create a measure using the formula.
count = IF(COUNT(Reservations[reservation])>0,"Yes",BLANK())
I try to reproduce your scenario using the following sample tables.
Then select the Tearchers[Name] as rows, the Rooms as column, the count measure as value. Set the rows and columns to show items with no data, so all the tearchers and rooms names can show.
Best Regards,
Angelia
Hi @JoLambrichts,
Please create relationship between Teachers and Reservations(one to many), Rooms and Reservations(one to many), then create a measure using the formula.
count = IF(COUNT(Reservations[reservation])>0,"Yes",BLANK())
I try to reproduce your scenario using the following sample tables.
Then select the Tearchers[Name] as rows, the Rooms as column, the count measure as value. Set the rows and columns to show items with no data, so all the tearchers and rooms names can show.
Best Regards,
Angelia
Thank you for this perfect answer.
Still a lot to learn for me.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |