cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
erogov
Frequent Visitor

Passing filter selected value to paramater

Hi, Gurus!
Sorry if this question was somewhere in forum, but i still didn't find the answer.

 

I have pDate parameter based on Date query values and FactTable that i want to filter by parameter pDate.

 

In Power BI i create two elements:

  • filter based on Date column from query Date
  • table with columns from FactTable

I would like to pass values selected in filter to my paramter pDate instead of selecting Manage Parameters menu and changing the values there.

My task is to reduce the output data from the database query and provide the user with a convenient filtering tool
I'm connected using Direct Query

 

Thanks, Egor

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Passing filter selected value to paramater

Hi @erogov ,

You said that you want to use parameter in report, visual or page filter, right? But this is not suppported currently. If you want to use parameter to filter it , you could click "edit parameters" , then change it and apply changes like below

586.PNG

Or you also could achieve this by in design or DAX level instead of Power Query. You could try to create relationship between date table and fact table, then use date table in slicer , which could also filter data in fact table.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Super User IV
Super User IV

Re: Passing filter selected value to paramater

Hi @erogov 

 

Direct Query includes filter context, so you don't need to pass any parameters.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

erogov
Frequent Visitor

Re: Passing filter selected value to paramater

@Mariusz thank you for feedback! 

You mean that the query goes to database include filter what i choose on sheet?
We can't check it because power bi don't have any profiler on his side, in our database side we can't check it too.

Thanks, Egor

Super User IV
Super User IV

Re: Passing filter selected value to paramater

Hi @erogov 

 

I think DAX studio can do it:

https://www.sqlbi.com/articles/analyze-directquery-requests-using-dax-studio/

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Community Support
Community Support

Re: Passing filter selected value to paramater

Hi @erogov ,

You said that you want to use parameter in report, visual or page filter, right? But this is not suppported currently. If you want to use parameter to filter it , you could click "edit parameters" , then change it and apply changes like below

586.PNG

Or you also could achieve this by in design or DAX level instead of Power Query. You could try to create relationship between date table and fact table, then use date table in slicer , which could also filter data in fact table.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors