Passing blank parameter to Embed report not working

[czs]

Hi team

I want to filter some blank value in string type in embed report and I checked the original post Solved: How to remove (Blank) value using URL Filtering - Microsoft Fabric Community , but it doesn't worked.

The original data is 

and '1'/'2'.. can be filtered by url parameter

but the blank doesn't work, and I have tried blank,null, (Blank), etc...

Please help, thanks in advance

[czs]

@Anonymous  thanks for your clarify and help.

I have implemented something similiar as you mentioned in my project.

But I do recommend microsoft help implement the blank filter in the feature, since the "null" and "Blank" have different meaning in business and we can't calculate every column to blank. 

[Anonymous · Accepted solution]

Hi @czs ,

Thank you for posting in this community.

Currently this is by design that we cannot use the URL query string parameter to filter null or blank

As a workaround, we can use the following syntax to create a calculated column to check if the original column is null:

Column = IF(LEN('Table'[String])>0,"NotBlank","Blank")

Then we can filter the embed report with the new created column as shown below:

&filter=Table/Column eq 'Blank'

Or you can simply replacing the blank values to text "Blank", and then try Filter=TableName/ColumnName eq 'Blank'

Similar issue for your reference:

Solved: Parameter filter in url when looking for "BLANK" v... - Microsoft Fabric Community

Best Regards,

Joyce,

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