cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yuching_chang
Helper II
Helper II

In matrix, when Value is "Show on row", how to hide a row when the value is blank for the whole row?

Hi there,

 

I have a matrix and with 2 values - "Value" and "RC" set as "show on row", and a multi-select slicer "Level" 

Capture2.PNG

 

Capture1.PNG

 

As you can see from the above, some Collab names, the RC is blank for the whole row, and this happens to all levels.

So, wondering if the "RC" value is all blank, can we hide the whole row? but still I need to show the row of another value - "Value" 

 

Thanks

2 REPLIES 2
v-xulin-mstf
Community Support
Community Support

Hi @yuching_chang,

 

Here is a related post, maybe it works.

 

Best Regards,

Link

lbendlin
Super User III
Super User III

Not really.  You can only do that with row fields, not with value fields. Can you find a way to use a calculated column instead that you could add to the rows well?

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.