https://community.fabric.microsoft.com/t5/Report-Server/Filtering-out-blank-values-in-Power-BI-Report-Builder/m-p/4341330#M39032 <P>Hi,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="472779" data-lia-user-login="Julia2023" class="lia-mention lia-mention-user">Julia2023</a>&nbsp;</P> <P>Based on your information, I create a sample table.</P> <P><img /></P> <P><img /></P> <P>&nbsp;</P> <P>Right-click the Data Region and select Properties. In the properties dialog box, go to the Filters tab and click the Add button to add a new filter.</P> <P><img /></P> <P><img /></P> <P>&nbsp;</P> <P>In the new filter expression, set the Expression to the field you want to filter on. For example, set Name, set the Operator to &lt;&gt; (not equal to), set the Value to a null value, and enter nothing.</P> <P><img /></P> <P>Here is preview:</P> <P><img /></P> <P>&nbsp;</P> <P style="margin: 6.0pt 0cm 0cm 0cm;"><SPAN><A title="https://community.powerbi.com/t5/community-blog/how-to-get-your-question-answered-quickly/ba-p/38490" href="https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FCommunity-Blog%2FHow-to-Get-Your-Question-Answered-Quickly%2Fba-p%2F38490&amp;data=05%7C02%7Cv-yohua%40microsoft.com%7Ce1106bfabecb4734a5cc08dc2305bc51%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638423754744679080%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&amp;sdata=24%2BceC5sFd3n3%2FhFDYILWFcNjCwVClBD%2BPBsSLVfJGk%3D&amp;reserved=0" target="_blank" rel="noopener">How to Get Your Question Answered Quickly</A></SPAN></P> <P style="margin-bottom: 6.0pt;"><SPAN>Best Regards</SPAN></P> <P style="margin-bottom: 6.0pt;"><SPAN>Yongkang Hua</SPAN></P> <P style="margin-bottom: 6.0pt;"><SPAN>If this post <STRONG>helps</STRONG>, then please consider <STRONG>Accept it as the solution</STRONG> to help the other members find it more quickly.</SPAN></P> Tue, 24 Dec 2024 02:03:05 GMT Anonymous 2024-12-24T02:03:05Z https://community.fabric.microsoft.com/t5/Report-Server/Filtering-out-blank-values-in-Power-BI-Report-Builder/m-p/4340863#M39031 <P>Hi community, I'm looking for help with adding a filter in Power BI Report Builder to&nbsp;to filter out blank values. Thanks!</P> Mon, 23 Dec 2024 13:35:39 GMT https://community.fabric.microsoft.com/t5/Report-Server/Filtering-out-blank-values-in-Power-BI-Report-Builder/m-p/4340863#M39031 Julia2023 2024-12-23T13:35:39Z https://community.fabric.microsoft.com/t5/Report-Server/Filtering-out-blank-values-in-Power-BI-Report-Builder/m-p/4341330#M39032 <P>Hi,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="472779" data-lia-user-login="Julia2023" class="lia-mention lia-mention-user">Julia2023</a>&nbsp;</P> <P>Based on your information, I create a sample table.</P> <P><img /></P> <P><img /></P> <P>&nbsp;</P> <P>Right-click the Data Region and select Properties. In the properties dialog box, go to the Filters tab and click the Add button to add a new filter.</P> <P><img /></P> <P><img /></P> <P>&nbsp;</P> <P>In the new filter expression, set the Expression to the field you want to filter on. For example, set Name, set the Operator to &lt;&gt; (not equal to), set the Value to a null value, and enter nothing.</P> <P><img /></P> <P>Here is preview:</P> <P><img /></P> <P>&nbsp;</P> <P style="margin: 6.0pt 0cm 0cm 0cm;"><SPAN><A title="https://community.powerbi.com/t5/community-blog/how-to-get-your-question-answered-quickly/ba-p/38490" href="https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FCommunity-Blog%2FHow-to-Get-Your-Question-Answered-Quickly%2Fba-p%2F38490&amp;data=05%7C02%7Cv-yohua%40microsoft.com%7Ce1106bfabecb4734a5cc08dc2305bc51%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638423754744679080%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&amp;sdata=24%2BceC5sFd3n3%2FhFDYILWFcNjCwVClBD%2BPBsSLVfJGk%3D&amp;reserved=0" target="_blank" rel="noopener">How to Get Your Question Answered Quickly</A></SPAN></P> <P style="margin-bottom: 6.0pt;"><SPAN>Best Regards</SPAN></P> <P style="margin-bottom: 6.0pt;"><SPAN>Yongkang Hua</SPAN></P> <P style="margin-bottom: 6.0pt;"><SPAN>If this post <STRONG>helps</STRONG>, then please consider <STRONG>Accept it as the solution</STRONG> to help the other members find it more quickly.</SPAN></P> Tue, 24 Dec 2024 02:03:05 GMT https://community.fabric.microsoft.com/t5/Report-Server/Filtering-out-blank-values-in-Power-BI-Report-Builder/m-p/4341330#M39032 Anonymous 2024-12-24T02:03:05Z