Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |