top of page

TRUE = FALSE? Highlighting Trick!

A couple of weeks ago, I talked about using a Dummy calculated field to remove a highlight. There is another method that works as well.

Want to see a video on these steps? Check it out here > Link


Simply create both Calculated fields below;





Place these fields on the Detail of your worksheet.

Then on the dashboard add a Filter action from the Dashboard > Actions menu.

In the example below I am selecting the Bar chart as the source sheet. Then I am also selecting the Bar chart as the Target Sheet.

I then had to add pick Selected fields and select FALSE from the drop-down in the first row. Then I selected TRUE for the Target Field (from the second drop-down).

Since "TRUE" will never equal "False" then the fields will also never highlight.

185 views0 comments


bottom of page