topic Re: Filtering different data points with the same name in Power Query https://community.fabric.microsoft.com/t5/Power-Query/Filtering-different-data-points-with-the-same-name/m-p/3092267#M98685 <P>it will be better to show us what the result you want.</P> Wed, 22 Feb 2023 08:11:34 GMT wdx223_Daniel 2023-02-22T08:11:34Z Filtering different data points with the same name https://community.fabric.microsoft.com/t5/Power-Query/Filtering-different-data-points-with-the-same-name/m-p/3087109#M98469 <P>Hi everyone,</P><P>&nbsp;</P><P>Referring to the picture below, was there a way to filter and create new tables based on the sex of the patient only and the sex of the provider only. Unforunatey the subheadings have made it difficult to differentiate on Power BI</P><P><img /></P><P>Thanks,</P><P>Roskalnikov</P> Mon, 20 Feb 2023 05:36:40 GMT https://community.fabric.microsoft.com/t5/Power-Query/Filtering-different-data-points-with-the-same-name/m-p/3087109#M98469 Roskalnikov 2023-02-20T05:36:40Z Re: Filtering different data points with the same name https://community.fabric.microsoft.com/t5/Power-Query/Filtering-different-data-points-with-the-same-name/m-p/3087143#M98471 <P>I've figured removing rows using alternating rows to be the best solution thus far, but if anyone has any better propositions, I would ve interested in hearing.&nbsp;</P> Mon, 20 Feb 2023 05:53:58 GMT https://community.fabric.microsoft.com/t5/Power-Query/Filtering-different-data-points-with-the-same-name/m-p/3087143#M98471 Roskalnikov 2023-02-20T05:53:58Z Re: Filtering different data points with the same name https://community.fabric.microsoft.com/t5/Power-Query/Filtering-different-data-points-with-the-same-name/m-p/3092201#M98678 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="473810" data-lia-user-login="Roskalnikov" class="lia-mention lia-mention-user">Roskalnikov</a>&nbsp;,</P> <P>&nbsp;</P> <P>You can filter the rows by clicking on the triangle below.</P> <P><img /></P> <P>&nbsp;&nbsp;&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> <P>&nbsp;</P> Wed, 22 Feb 2023 07:25:30 GMT https://community.fabric.microsoft.com/t5/Power-Query/Filtering-different-data-points-with-the-same-name/m-p/3092201#M98678 Anonymous 2023-02-22T07:25:30Z Re: Filtering different data points with the same name https://community.fabric.microsoft.com/t5/Power-Query/Filtering-different-data-points-with-the-same-name/m-p/3092267#M98685 <P>it will be better to show us what the result you want.</P> Wed, 22 Feb 2023 08:11:34 GMT https://community.fabric.microsoft.com/t5/Power-Query/Filtering-different-data-points-with-the-same-name/m-p/3092267#M98685 wdx223_Daniel 2023-02-22T08:11:34Z