topic Re: When using Groupby in PowerBI some of the rows after grouping is blank, though source is not blank in Power Query https://community.fabric.microsoft.com/t5/Power-Query/When-using-Groupby-in-PowerBI-some-of-the-rows-after-grouping-is/m-p/3247390#M104635 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="558528" data-lia-user-login="VenkiCed" class="lia-mention lia-mention-user">VenkiCed</a>&nbsp;please share you dummy dataset for more understanding.THANK YOU!!</P> Mon, 22 May 2023 11:22:43 GMT Mahesh0016 2023-05-22T11:22:43Z When using Groupby in PowerBI some of the rows after grouping is blank, though source is not blank https://community.fabric.microsoft.com/t5/Power-Query/When-using-Groupby-in-PowerBI-some-of-the-rows-after-grouping-is/m-p/3246867#M104624 <P><img /></P><P>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.&nbsp;</P> Mon, 22 May 2023 08:16:34 GMT https://community.fabric.microsoft.com/t5/Power-Query/When-using-Groupby-in-PowerBI-some-of-the-rows-after-grouping-is/m-p/3246867#M104624 VenkiCed 2023-05-22T08:16:34Z Re: When using Groupby in PowerBI some of the rows after grouping is blank, though source is not blank https://community.fabric.microsoft.com/t5/Power-Query/When-using-Groupby-in-PowerBI-some-of-the-rows-after-grouping-is/m-p/3247390#M104635 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="558528" data-lia-user-login="VenkiCed" class="lia-mention lia-mention-user">VenkiCed</a>&nbsp;please share you dummy dataset for more understanding.THANK YOU!!</P> Mon, 22 May 2023 11:22:43 GMT https://community.fabric.microsoft.com/t5/Power-Query/When-using-Groupby-in-PowerBI-some-of-the-rows-after-grouping-is/m-p/3247390#M104635 Mahesh0016 2023-05-22T11:22:43Z Re: When using Groupby in PowerBI some of the rows after grouping is blank, though source is not blank https://community.fabric.microsoft.com/t5/Power-Query/When-using-Groupby-in-PowerBI-some-of-the-rows-after-grouping-is/m-p/3254364#M104908 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="558528" data-lia-user-login="VenkiCed" class="lia-mention lia-mention-user">VenkiCed</a>&nbsp;,</P> <P>&nbsp;</P> <P>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.</P> <P>&nbsp;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</P> <P>Best Regards,</P> <P>Stephen Tao</P> <P>&nbsp;</P> <P>If this post&nbsp;<EM><STRONG>helps</STRONG></EM>, then please consider&nbsp;<EM><STRONG>Accept it as the solution</STRONG></EM>&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> Fri, 26 May 2023 03:01:05 GMT https://community.fabric.microsoft.com/t5/Power-Query/When-using-Groupby-in-PowerBI-some-of-the-rows-after-grouping-is/m-p/3254364#M104908 Anonymous 2023-05-26T03:01:05Z