Forum Discussion
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 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
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 TeamIf 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
1 Reply
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 TeamIf 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