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 (8)
- Merged Idea (2)
RE: Formatting True/False data
Allow choices of "Yes/No", "Y/N", "T/F", "1/0"
RE: Formatting True/False data
please give us some formatting options for boolean fields so that we can save the data model size. Storing Yes/No increases the column size by factor 10!!! And currently we either have to provide bad user experience with True/False or use Yes/No and get bloated data models. The best would be if we can just type any two strings into the Ribbon Field Format field and it would automatically use those. Power BI already lets me enter something there and it saves. But it does not get applied to visuals. Examples: Yes / No On / OffEnabled / Disabled
RE: Formatting True/False data
This is so totally needed. Otherwise, you have to duplicate all the boolean columns, just to have a calculated column to show what should be displayed. That adds greatly to model complexity, adds to size, and increases processing time, really for no reason.For example, column might be Is Acceptable but perhaps the data needs to show OK or blank.
RE: Formatting True/False data
@Amando I agree, language depending display of different texts (true/false, yes/no, open/closed, ...) would be great. At least a possibility to define user specific texts for a column to be displayed instead of TRUE/FALSE.
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.
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?