Forum Discussion
Do not show the first row values when expanded using matrix
Hi there,
I've managed to find a workaround for this. It's not the best but it's a very simple procedure. First of all, you have to know the main colors of your report.
So you go to the "Cell elements" property of your matrix, enable "Font color" and in the 'fx' button you have to configurate accordingly to your report colors. You set the collapsed value to be the same color as your background (in my example, white) and the expanded to be the one you want for your fonts.
Set the range based on your data (in this case I've put anything between 2 and 40), remembering that for PowerBI this means the total count of the subrows under the main row. The other rule you set to "1" since the count will be allways 1 when you expand the rows (you have to be using two-level matrix to work exactly like above).
It'll be something like this:
Regards,
Mr. Barbosa