Forum Discussion

garythomannCoGC's avatar
garythomannCoGC
Impactful Individual
4 years ago
Solved

power 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...
Need Help
  • garythomannCoGC's avatar
    garythomannCoGC
    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 :}

Jhon_Smitrh's avatar
Jhon_Smitrh
New Member
8 months ago

You might also consider adding a clear default or explanatory note when allowing blank values, as it helps reduce confusion for report users. In some cases, pairing blank options with conditional logic can prevent unexpected results in visuals. I’ve seen similar clarity approaches applied outside BI as well, such as how Property Search Palm presents optional data fields without affecting accuracy. A short description or validation rule often improves overall usability.