Not showing rows with blank or null values.

[Harry123]

 

Dear all,

I made a table on power Bi showing different attributes from an item. The table is based on a filter where I can select one item from  a list. I would like that when i select an item, the table only shows the columns where the attributs arent null. For this exemple the table would only show the value of ACIDIC and hide the rest. For orther items the columns that are blank here could have values thats why I must leave them in the table fields.  I tried selecting "is not blank" in the filters pane for each column but this doesnt work as it also erases the columns that do have values. How could I do this?

Kind regards 

[iAM_BA]

Hi @Harry123 

Please chcek link - 
https://community.fabric.microsoft.com/t5/Desktop/Row-with-blank-value-disappear-from-table/m-p/1284...

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.