Forum Discussion
Advocate IGroup type list does not show value zero under Ungrouped values
Hi, I am using the new feature Binning/Groups. When I select the Group type list, the value zero does not appear under the "Ungrouped values" selection, although I do have zero values in the columns.
I also tried creating a new column with just zero value, and in this case, the 'Ungrouped values" selection was empty.
Any idea how to resolve this?
Please download the Jan 2017 version of Power BI Desktop. This issue should has been fixed now.
Best Regards,
Herbert
6 Replies
v-haibl-msftMicrosoft Employee
In order to group numeric data as categories you can change the column type to "text". Then the "0" value shall be present in the ungrouped values list.
- Select numeric column in the Field List
- Switch to Modeling ribbon tab
- Click on the Data Type dropdown in ribbon and pick the "Text" data type
- Right click on the field and select New Group from context menu Result: 0 values is shown in the dialog
Best Regards,
Herbert
JimNThanks, that worked. But this method requires me to create a new duplicated column to have the text type, as i need the original column to remain as numeric type. Can you fix this issue to make it work for numeric column types as well?
- v-haibl-msft
Fix will be available in the January 2017 release of the desktop. Please check it later.
Best Regards,
Herbert
v-sihou-msft