How to pass parameter created through ManageParamter to a query that can use this value to filter

[CheenuSing]

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

[ImkeF · Accepted solution]

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:

[CheenuSing]

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

[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

[CheenuSing]

Hi @MarcelBeug,

If this is possible can you please advise the steps.

Cheers

CheenuSing