Group type list does not show value zero under Ungrouped values

[JimN]

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?

[v-haibl-msft]

@JimN

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.

1. Select numeric column in the Field List
2. Switch to Modeling ribbon tab
3. Click on the Data Type dropdown in ribbon and pick the "Text" data type
4. Right click on the field and select New Group from context menu Result: 0 values is shown in the dialog

Best Regards,

Herbert

[JimN]

Thanks, 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]

@JimN

Fix will be available in the January 2017 release of the desktop. Please check it later.

Best Regards,

Herbert

[JimN]

Thanks! Looking forward to it.

[v-haibl-msft · Accepted solution]

@JimN

Please download the Jan 2017 version of Power BI Desktop. This issue should has been fixed now.

Best Regards,

Herbert

[v-sihou-msft]

@JimN

I reproduced same issue as yours. The zero values are not included "Ungrouped  Values".

We have reported this issue internally. You can also submit an issue.

Regards,