Forum Discussion

czs's avatar
czs
New Member
2 years ago
Solved

Passing blank parameter to Embed report not working

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

czs's avatar
czs
New Member
2 years ago

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.