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

Steps

Simply create both Calculated fields below;

TRUE

True

FALSE

False

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.