Forum Discussion

DJsummers's avatar
DJsummers
Helper I
3 years ago
Solved

Conditional Formatting to filter out blank values

Hi, I have a very simple table which looks like below, which counts the amount of entries against each H1, H2, etc.


I am filtering it via a category, which in my case, is farms. Not all farms have 6 houses, so I have used conditional formatting to filter it to the below when the value is 0:

My question is, how would I also go about blocking out H4, H5 & H6 in this example? But also for any other values that are zero, also make text and background white for the houses?

As always, any help much appreciated.
Greg_Deckler PhilipTreacy amitchandak 

Dan



 

 

  • DJsummers , If you are using measures you can not hide them when value is blank. You can create a calculation group and try out

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0 

1 Reply

  • DJsummers , If you are using measures you can not hide them when value is blank. You can create a calculation group and try out

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0