PowerBI Report Builder-Parameters Operator Range

[CreativeSteph]

I'm trying to use a parameter with a range of integers in "Days Since Last HIV Viral Load" such as a range from 28 - 33.  It filters in query designer, but when I run the report I get an error...  I'm wondering if it's because it won't allow me to "Allow blank value (")", since I do have blanks...

[v-yangliu-msft]

Hi  @CreativeSteph ,

You can try changing it to text format

This is the related document, you can view this content:

The property ‘ValidValues’ of report parameter ‘Tr... - Microsoft Power BI Community

Data types in expressions in a paginated report - Microsoft Report Builder & Power BI Report Builder...

Report parameters in Power BI Report Builder - Power BI | Microsoft Docs

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.