Forum Discussion
Matrix nested rows - hiding values that are in subrows
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?
For your reference.
M_Sum = IF(HASONEVALUE('Data'[Company]),BLANK(),SUM(Data[Daily Sales ( Through a measure)]))
M_HNV = HASONEVALUE(Data[Company])
3 Replies
mickey64, this is exactly what I needed. Thank you, very much for the solution!
For your reference.
M_Sum = IF(HASONEVALUE('Data'[Company]),BLANK(),SUM(Data[Daily Sales ( Through a measure)]))
M_HNV = HASONEVALUE(Data[Company])
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.
