Forum Discussion
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 | 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
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.
3 Replies
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.
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!
dalmn21 Make the header row the same color as the background? Put a filled rectangle over the header?
