Matrix nested rows - hiding values that are in subrows

[dandreev]

Hi All,
I have a matrix that it has nested rows. Is it possible to see just the bold numbers and 'hide'(remove) the other values that are corresponding to the nested rows?

[dandreev]

@mickey64, this is exactly what I needed. Thank you, very much for the solution!

[audreygerred]

When you hover on the visual you should see some icons appear in upper right or lower right of the visual. If you click the first one (an up arrow) it will collapse the indented column and only show the bold items. Then, the user can expand using the + icon or the icons that appear when they hover. If you don't want them nested at all, remove that field from the rows of your matrix.

[mickey64 · Accepted solution]

For your reference.

M_Sum = IF(HASONEVALUE('Data'[Company]),BLANK(),SUM(Data[Daily Sales ( Through a measure)]))

M_HNV = HASONEVALUE(Data[Company])