Forum Discussion

RandomDept's avatar
RandomDept
New Member
3 months ago
Solved

Can I format a visualisation to display matrix data like a table?

Not sure if the title is 100% acurate, but very new to PowerBI / Tables in general.

 

I have a data source that contains the below fields


User (Users full name)

Email (Users email address) They can have more than one

Environment (Power Platform Environment member) Power Apps Environment of which they are a member, they can have multiple

Security Role (Power Platform Security role for the environment) They can have multiple.

 

This is an example data set:

UserEmailEnvironmentSecurity Role
Ben Clark[email protected]Default EnvironmentEnvironmet Maker
Ben Clark[email protected]Default EnvironmentBasic User
Ben Clark[email protected]MetropolisEnvironment Maker
Dave Phill[email protected]Default EnvironmentEnvironmet Maker
Dave Phill[email protected]Default EnvironmentBasic User
Dave Phill[email protected]GothamBasic User
Grant Stone[email protected]MetropolisBasic User
Steve Rocks[email protected]GothamSystem Administrator
Steve Rocks[email protected]Default EnvironmentEnvironmet Maker
Steve Rocks[email protected]Default EnvironmentBasic User
Steve Rocks[email protected]GothamBasic User
Steve Rocks[email protected]RiverdaleBasic User

 

I want to format it so the username, email and environment names are not repeated for each user.

The ideal format I am after would display like this:


UserEmailEnvironmentSecurity Role
Ben Clark[email protected]Default EnvironmentEnvironmet Maker
   Basic User
  MetropolisEnvironment Maker
Dave Phill[email protected]Default EnvironmentEnvironmet Maker
   Basic User
  GothamBasic User
Grant Stone[email protected]MetropolisBasic User
Steve Rocks[email protected]GothamSystem Administrator
Steve Rocks[email protected]Default EnvironmentEnvironmet Maker
   Basic User
  GothamBasic User
  RiverdaleBasic User

 

 

Does anyone know how I can achieve this?

 

Thank you

RD

Need Help
Tips and Tricks
  • danextian's avatar
    danextian
    3 months ago

    Hi RandomDept 

    Use the matrix visual with all  fields added as a row category well and set the layout to outline

     

    Note: There isn't currently no option to turn on/off the weight of a row header category so all fields in the higher level hierarchy will be in bold.

3 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    3 months ago

    Hi RandomDept 

    Use the matrix visual with all  fields added as a row category well and set the layout to outline

     

    Note: There isn't currently no option to turn on/off the weight of a row header category so all fields in the higher level hierarchy will be in bold.

    • Fenil_Italiya's avatar
      Fenil_Italiya
      Icon for Advocate I rankAdvocate I
      3 months ago

      Hello, danextian Your Answer is correct, but if you want to remove the boldness of the row subtotals you can use this option enable in the row subtotals that

      -> try to remove boldness and also select apply to label option as well so you get this type of output;

      -> I hope this will helps you and RandomDept also.

      -> You can use this blog for the reference : Matrix Row Headers 

      -> If it helps you do not forget to give kudos.