Forum Discussion
How to pass parameter created through ManageParamter to a query that can use this value to filter
Hi ImkeF , TomMartens
1. I created a paremeter called Level3 using ManagePAramter.
2. I have a query to do transformation called ExtractData
3. As the last step in the ExtractData query I want to pass the value in Level3 parameter.
4. Also next time when use Edit Parameters and change the value I should get a new set of rows based on the value entered.
How to acheive this ?
Cheers
CheenuSing
Sorry, was busy. Here is a good reference:
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
This missing bit might be how to use the parameter in the M code:
Perform the desired filter-operation by using a hardcoded value like this:
and then repalce it by a reference to your parameter:
4 Replies
- ImkeF
Community Champion
Sorry, was busy. Here is a good reference:
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
This missing bit might be how to use the parameter in the M code:
Perform the desired filter-operation by using a hardcoded value like this:
and then repalce it by a reference to your parameter:
Hi ImkeF,
By the time your reply arrived , I had done the same thing as suggested by you.
Just one more calrification , how to reference a table generated by a earlier query in another query.
I have a query called EMPMASTER. I am creating another query to filter records from the output table of this query, in another query to filter records using parameter values.
Cheers
CheenuSing
Hi ImkeF,
Sorry for the trouble. I got it working , it was a typo error in the name of the previously stored query.
Thank you for your support at all times.
Cheers
CheenuSing