Forum Discussion
Remove a single blank row from a matrix
- 6 years ago
hi, Anonymous
To my knowledge, I'm pretty sure there isn't an elegant way to do this at this time.
Here are some related ideas you can vote and comment on to add your support to encourage Microsoft to fix this limitation:
Show/Hide columns in report based on expression.
and here is a workaround that you may refer to:
Create a separate dim table just with measure name as below:
Then create another measure:
Measure = IF(SELECTEDVALUE('Table'[Type])="Average",[Average] ,IF(SELECTEDVALUE('Table'[Type])="Count",[Count]))Now drag the field Type from this new table and this new measure into a visual.
and here is sample pbix file, please try it.
Best Regards,
Lin
Try using the Filters pane to select the measure in questions and apply a filter of 'is not blank'.
- Anonymous6 years agoNot applicable
This filters the complete matrix, not just the row that I am interested in so I end up with no rows at all