Forum Discussion
Stacked Records as a table
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.
Hi Magrfa ,
I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.
Thank you.
Thanks all for the ideas, No I have not yet got quite what I am after.
In my original the tables on the Left are the source the table on the right is how I am after to display it.
I originally had this in an Excel spredsheet managed manually, i was hoping to automate it with PowerBI, Here is a screenshot of the Excel layout, I have had to blurr it to protect the people's Names
In PowerBI I have:
A table with the User Profiles and a unique identifier (16 hexadecimal characters)
A Table of Users and against each user the unique identifier of the User Profile, Also a numeric value in another field 1-7
What I am after is to have the User Profiles across the top and then list the users underneath against the relevent User Profile, as per the Screenshot, then the numeric value of 1-7 indicated the status of the user and that controls the colour