dont show column if measure value for max(date) in pivot table is null or 0

[stavc]

hey all,

I have the following pivot table:
I want that if the value in "area"=0  or is null, in the latest date (in this example in 01/29/2019) then it will not show this block name at all. which means, that in this case, I want to get a pivot table without block "Ranch7", because this block are in the latest date is 0.

if this is not possible, i would like to know if there is any option to color the background of the "area" for the latest date if there is null or 0.

Thank you in advance!

[Gysbert_Wassenaar]

It's not possible. Every expression will be shown in a column for every dimension value if for any dimension value the expression has at least one non-zero value. The pivot table does not support text and background colors for expressions yet.