Forum Discussion
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 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
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.
2 Replies
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.
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.
