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
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.