Can we hide the first row record in the matrix visual

[Anonymous]

Can we hide the first row record in the matrix visual? As it is showing duplicate records as below -

[Ritaf1983]

Hi @Anonymous 
Yes, there is a few options to "hide" the subtotal (first marked row) .
As you aren't using measure, you can switch off subtotals :

Or if you need the subtotals for other columns which numeric, you can make the unneeded "white" :

The pbix with both examples is attached

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

[Anonymous]

Hi @Ritaf1983 , Thank you so much for your help.

It is working now but can we also hide below highlighted rows from first columns? reuirement is that these values should be there in the next column.

[Ritaf1983 · Accepted solution]

Hi again 🙂

You won't be able to hide these because they are not "values" but categories.

If you want to prevent duplication, don't include the recurring category in the "values" column.

Leave it only in the ROWS and change the layout to tabular.

The updated pbix is attached

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