Forum Discussion

dalmn21's avatar
dalmn21
Frequent Visitor
2 years ago
Solved

Hide Row in Matrix

Hi,    I want to hide the rows of a column in a matrix, but not running across anything that's helping me.  My matrix is similar to this:  Month Jan Jan Jan Name Pay Per Hour Sales To...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi dalmn21 

     

    Since Power BI does not directly allow hiding row headers while keeping the data, you can create a calculated column in your data model that anonymizes or replaces the employee names.

    NName = "name" & RANKX(ALL('Table'),'Table'[name],,ASC)

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi dalmn21 

 

Since Power BI does not directly allow hiding row headers while keeping the data, you can create a calculated column in your data model that anonymizes or replaces the employee names.

NName = "name" & RANKX(ALL('Table'),'Table'[name],,ASC)

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • dalmn21's avatar
    dalmn21
    Frequent Visitor
    2 years ago

    Thank you so much for your help! It works, but I have one question. I created the column and added it to my matrix, the names become "name [numbers]", I assume it's from the RANKX function that's adding the numbers behind the name. Is there a way I can just have it say "name" for all the names? Thank you!