Forum Discussion

naveen73's avatar
naveen73
Icon for Helper III rankHelper III
2 years ago
Solved

parameters filtering

Hi All, I had a question about parameters.   Suppose I have a table in PQ with the names and age. I make two parameters to filter on name and age through Excel cells. How can I change the paramet...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi naveen73 ,

    Try unchecking required box when creating the parameter:

    Then modify the filter query, like:

    Returns true when a null value is passed as a parameter.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi naveen73 ,

Try unchecking required box when creating the parameter:

Then modify the filter query, like:

Returns true when a null value is passed as a parameter.

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum