Forum Discussion
garythomannCoGC
Impactful Individual
4 years agopower bi report builder - parameter property - "allow blank value"
Revisting Power BI Report Builder (SSRS in my case) after some years and wondering how the 'Allow blank value ("")' property works in Power BI Report Builder? Had a play with a report I am ta...
- 4 years ago
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 :}
garythomannCoGC
Impactful Individual
4 years agoNote to self to cross check with these issues
Unable to use "Allow null value" on report builder 15.x version