When using Groupby in PowerBI some of the rows after grouping is blank, though source is not blank

[VenkiCed]

Above is screeshot from PowerBI, Groupby is performed based on the data in "Risk Value", value is 1. but in groupby column it is blank. 

[v-stephen-msft]

Hi @VenkiCed ,

This issue can occur when the column used for grouping contains null or blank values. To resolve this issue, you can try to replace blank with 0 in Power Query.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Mahesh0016]

@VenkiCed please share you dummy dataset for more understanding.THANK YOU!!