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


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.



113 views0 comments

Comments


bottom of page