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 (9)
- Merged Idea (2)
RE: Formatting True/False data
Much needed feature. Please provide some default options to display True/False boolean values as Yes/No, Y/N, On/Off, Open/Closed, Enabled/Disabled, etc. Even better to allow custom format strings (just like what the date/time data type already supports).There are not many votes here, not because this feature is not needed, but because the customers currently can get by with a calculated column translating True/False to Yes/No or whatever they need. But that inflates the data model and results in an ugly solution.On top of this idea, how about add another Power BI function "Display as"? Just like Power BI allows you to sort one column by another column, maybe allow to display the values of a column based on another lookup table manually entered in Power Query as part of the data model? I think that will be a generic solution to many problems currently faced by many silent customers!
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?