Forum Discussion
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
- amitchandakSuper User
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