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

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.