parameters filtering

[naveen73]

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 parameter so that I can have all the names when I only want to filter on the age column (or the other way around: just filter on name and not filter on age)?

Currently, there has to be a value otherwise I am getting an error message.

Thanks,

Naveen

[v-cgao-msft · Accepted solution]

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