Hide Row in Matrix

[dalmn21]

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	Total Pay
John Doe	20	126	2431
Jane Doe	23	115	2502

I want to hide the names of the employees but still have their data shown. 

Month	Jan	Jan	Jan
	Pay Per Hour	Sales	Total Pay
	20	126	2431
	23	115	2502

Is there a way to do this? My name column is in the 'Rows' field, month is in the 'Columns' field, and pay per hour, sales, and total pay are in the 'Values' column 

[Anonymous · Accepted solution]

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]

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! 

[Greg_Deckler]

@dalmn21 Make the header row the same color as the background? Put a filled rectangle over the header?