Forum Discussion
Hide values in matrix visual while the rows are collapsed
Hi all! I'm hoping someone can point me along the right direction: I'm trying to hide visuals while matrix rows are collapsed, but display them on expansion. I have the following table: C...
You can use a measure
Right click on table name and pick "new measure".
On formula bar type:
Item_Key = IF(COUNT(Table[Item Key] = 1, SUM(COUNT(Table[Item Key]), BLANK())In your Matrix visual, use that measure instead of Item Key column.