topic Re: How can I hide the column in Pivot table in App Development

How can I hide the column in Pivot table

AndersLiu — Thu, 04 Mar 2021 08:02:11 GMT

Re: How can I hide the column in Pivot table

GaryGiles — Thu, 04 Mar 2021 10:13:37 GMT

In the properties panel of your pivot table, look for the option of "Show column if". In the expression box for "Show column if", you could use something like this:

=if(not isnull(expression),1,0)

Replacing expression with the expression for the measure. In this way, if the values are Null, the column will be hidden.

Re: How can I hide the column in Pivot table

AndersLiu — Fri, 05 Mar 2021 02:47:01 GMT

Thank you GrayGiles,This Colum expression need to display in one categories。But in my structure it has display in four categories。

And my expression:

Pick(Match(BrandColumn ,'Evolution Index')

,MaxString({<[Market.Product]={$(vNonVBPBrand)}>}[Target EI])

)