Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
naveen73
Helper III
Helper III

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

 

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Hi @naveen73 ,

Try unchecking required box when creating the parameter:

vcgaomsft_0-1697594896635.png

Then modify the filter query, like:

vcgaomsft_1-1697594961745.png

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

View solution in original post

1 REPLY 1
v-cgao-msft
Community Support
Community Support

Hi @naveen73 ,

Try unchecking required box when creating the parameter:

vcgaomsft_0-1697594896635.png

Then modify the filter query, like:

vcgaomsft_1-1697594961745.png

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors