Replace boolean 1 and 0 values with user-friendly strings

Question & Answer
1

Hi,
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

2 Likes
2

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