Skip to main content

Power BI

New

Formatting True/False data

Vote (22) Share
Fabian Valencia's profile image

Fabian Valencia on 23 Jun 2017 21:21:58

Boolean columns or measures are shown as True or False. That from a computer programming perspective is perfectly fine, we know 1 or 0, True or False. But for a dashboard that is meant to be used by other people, it does not seem like the friendliest option. Instead of True/False, why not allow Boolean collumns to be shown as Yes/No, Y/N. Consider a column called IsHedged and values of True. Does it read better as IsHedged = No or IsHedged = false or Ishedged = N.

Comments (2)
Fabian Valencia's profile image Profile Picture

bf3b60e0 bd1c-4173-9ca1-e5f084de65da on 16 Aug 2020 04:09:13

RE: Formatting True/False data

If your language is different from English, it could be translated the text true or false ( show "verdadero"/"falso" o "Si"/"No" in Spanish). Even a differentiating icon or a check, to make it independent of the language.

Fabian Valencia's profile image Profile Picture

79b611ed 7f84-42e9-b680-29ea534c1e01 on 16 Aug 2020 04:04:51

RE: Formatting True/False data

This is absolutely a great idea and well expressed. I'm looking at this problem right now, users wish to see "yes" or "no" or another variation, true or false rarely works?