Forum Discussion
Solved
Stacked Records as a table
Hello All, I am trying to work out how I would do this. I have two tables which are linked, one is a list of users and the other is the user profiles. I want to display a table visual with the p...
Hi Magrfa ,
You can replicate your Excel layout using a Matrix visual in Power BI:
Create a relationship between Users[ProfileID] --> Profiles[ProfileID].
In the Matrix:
Columns - Profiles[ProfileName]
Rows - Users[UserID] (or Name)
Values - Users[Status] (set to Don’t summarize).
Apply conditional formatting on Status to color the cells based on values 1–7.
This way, profiles appear across the top, users are listed underneath, and their status controls the color - just like your Excel view, but dynamic in Power BI.
Thank you.
