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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Use parameters as filters in the visual

Hi. So I'm using the SQL - Table valued function in Power BI to visualise my data. the query is like this for example

'select x, y, z from fn.sample(@name, @starttime, @endtime)'

Where '@' are the parameters I need to pass in the query. I have created the parameters in power BI and published, and I can edit the parameter values in app.powerbi.com from the dataset, which is absolutely fine. But now instead of that whole process, I want to use the parameters as filters in the visual. There is no relationship between x,y,z and parameters, because none of them have common values (x - string value, y &z - integers, @name - string value(but not same values as x), @starttime, & @endtime - date). So I'm neither able to use those parameters as new column in the query nor create any relationship so I can use them as filters in the visual.

Any help would be appreciated.

Thanks in advance.

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,


Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

jaideepnema
Solution Sage
Solution Sage

Hi @Anonymous ,

I am not sure but check if this can be achieved using Dynamic M Query Parameter

Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs

 

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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