Forum Discussion

JimN's avatar
JimN
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Group 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...
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    JimN

     

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

     

    Best Regards,

    Herbert

     

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
    JimN
    Icon for Advocate I rankAdvocate I
    9 years ago

    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's avatar
      v-haibl-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      JimN

       

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

       

      Best Regards,

      Herbert

      • JimN's avatar
        JimN
        Icon for Advocate I rankAdvocate I
        9 years ago

        Thanks! Looking forward to it.