How Can dynamically hide the columns which are going to give some equal to zero ?

[Roshan_201295]

Hi 

I am working on power bi report there I have some finacial data.In that report I have table that containing some information but I want to see only those information which can give me some values at the total & I don't want see any column inside that table which is going to total equal to zero.

This should work for me dynamically for each slicer of the report.

Thank You !

[Roshan_201295]

I want this one for table only..If will apply that table it is not working for me

[TheoC · Accepted solution]

@Roshan_201295 you can do this for the Visual Filter level.  It will give you the outcome you want.

[TheoC]

Hi @Roshan_201295 

You can add the column with the values you are referring to in the "Filters on all pages" and select "Is not Blank".

This will eliminate anything that is blank from your data with respect to the specific column you add to this section.  Just ensure that you do some checks over this once you have added it so that you confirm you are getting the output you want.

Thanks heaps,
Theo