Replace boolean 1 and 0 values with user-friendly strings

As you know, Quicksight cast booleans as integers (1 and 0). I have a lot of boolean values I use in charts, and I hate to see “1” and “0” in my axis and legends, is there a way to replace this with user-friendly texts like true/false or yes/no ?
The goal is to avoid creating an additional string column with an if statement for each of my boolean field


Hey Martin,

There is no “Setting” that can change how to display all Booleans as something different.

Unfortunately you will need to create ifelse statements for the Booleans you have.

1 Like