Forum Discussion
Impactful Individualpower bi report builder - parameter property - "allow blank value"
Mmm somehow the only reponse got upgraded to 'Solved!' Hilarious, wasn't me.
Anyway still no answer to the 'Allow blank value ("")' property nor documentation. All my parameters have 'Allow multiple values' set. So maybe that is the issue, when not a multi-value parameter then the setting does something exciting :}
I have decided to as a work around to set
'All' to mean give me everything including blanks.
'NA' to mean 'blanks'.
'blanks' can be any of blank, null, 0, ‘Select’, ‘NA’, ‘Not Applicable’, "", " " as there is lots of interesting data :}
Hi garythomannCoGC ,
Power BI Report Server is based on SQL Server Reporting Services (SSRS), it brings the ability to work with Power BI reports completely on premises in addition to all the other capabilities of SSRS.
Regarding your question, perhaps you can refer to the following article to see if it can give you some help.
Your Reporting Services report has a multi-value parameter, but it does not display NULL in the parameter drop-down list along with other parameter values. in SSRS, multi-value parameters cannot contain NULL values, so the user cannot filter NULL values in the data.
However, sometimes user requirements indicate the need to be able to filter data for NULL values, so in this article below, the authors demonstrate in detail how to allow NULL values in multi-value SSRS report parameters.
Allow NULL value in Multi Value Report Parameter
Also，you can refer to some troubleshooting situations：
passing null values in reportviewer control parameters
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.