Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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