Not showing columns 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

[lbendlin]

That is not possible in Power BI.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41