Forum Discussion

Magrfa's avatar
Magrfa
Frequent Visitor
1 year ago
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...
Need Help
  • v-venuppu's avatar
    v-venuppu
    11 months ago

    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.

v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
1 year ago

Hi Magrfa ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Royel for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.