Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Remove a single blank row from a matrix

Good Afternoon,   I have created a matrix using two measures and a slicer, when one of the measures is <blank> I would like to hide just this row leaving the other measure visable, is this possible...
  • v-lili6-msft's avatar
    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:

    Hide/Show Column on Table

    Show/Hide columns in report based on expression.

    Power BI hide/show column

     

    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