Need help with dealing with null values as filter / parameter in embedded Power BI paginated report

[Anonymous]

Hi there,

I have two tables in my Power BI dataset where one is a fact table and another acts as a dimension table. When I do an inner join there are some null values on the dimension table and when I bring this information into Power BI report builder and embed the paginated report, I am having issues dealing with the null value.

Within report builder, I've been able to error handle so that the parameter I have with null values takes the field that "is nothing" and converts it to be blank so it works as a paginated report to bring the data into the report. However, once I embed the pagianted report and that field that I am filtering on is blank when joined together, it throws an error in desktop when running where that field is blank but if it has a value it's fine. How would you handle this?

[Anonymous]

Hi @Anonymous ,

You can try using the function in Power BI to handle null values in your dimension tableISBLANK. You can create a calculated column in your dimension table that checks if the value is null and returns a blank value if it is. Then, you can use this calculated column in your report instead of the original column to avoid errors when the field is blank. Another option is to use the function to check if the value is null and return a blank value if it is, or return the original value if it is not nullIF. You can also try using the function to replace null values with a default valueCOALESCE.

You can refer to the following documents that may be helpful to you:

Power BI Paginated Report parameters with (Null) v... - Microsoft Fabric Community

Empty and null data points in Power BI paginated report charts - Power BI | Microsoft Learn

Empty and null data points in paginated report charts - Microsoft Report Builder & Power BI Report Builder 

Best Regards,

Neeko Tang

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