Referencing one parameter within another parameter within Power Query

[Kieran]

Hi,

How do I reference one parameter within another parameter within Power Query...

For example I want to create a parameter representing an [Environment] representing the values "DEV", "UAT" and "PRD".

I also want to create another parameter representing the [Location] e,g, "www.mySales.com", "www.myPurchases.com", "www.myNominal.com"

The the third parameter references the first two parameters and is used in a data source definition.

Where for example the third parameter [FullPath] could equal "www.mySales.com\DEV" for instance.

So I was hoping to define the third parameter in the following way...

[FullPath] = [Location] & "\" & [Environment]

Can any one help?

[Anonymous · Accepted solution]

Hi @Kieran,

After defining the first two parameters, you must create a list by concatenating them.

let
Source = Location& "\" & Enviroment,
    #"Converted to List" = {Source}
in
    #"Converted to List"

And then create the third parameter by choosing the Query option in Suggested Values, and this new list as Query.

Regards.

[Anonymous · Accepted solution]

Hi @Kieran,

After defining the first two parameters, you must create a list by concatenating them.

let
Source = Location& "\" & Enviroment,
    #"Converted to List" = {Source}
in
    #"Converted to List"

And then create the third parameter by choosing the Query option in Suggested Values, and this new list as Query.

Regards.

[Kieran]

Hi,

When I change the first parameter and second parameter, the third parameter (based on the query option you stated) does not update to reflect the new contents of the first or second parameter,

LocationEnvironmentParameter

"www.myPurchases.com/UAT" meta [IsParameterQuery=true,
 ExpressionIdentifier=LocationEnvironmentList, Type="Text", 
IsParameterQueryRequired=false]

LocationEnvironmentList

let
Source = Location & "\" & Environment,
    #"Converted to List" = {Source}
in
    #"Converted to List"

Location

"www.myPurchases.com" meta [IsParameterQuery=true,
 List={"www.mySales.com", "www.myPurchases.com", 
"www.myNominal.com"}, DefaultValue="www.mySales.com", Type="Text", 
IsParameterQueryRequired=true]

Environment

"UAT" meta [IsParameterQuery=true, List={"DEV", "UAT", "PRD"}, 
DefaultValue="DEV", Type="Text", IsParameterQueryRequired=true]

Any thoughts?

I wonder if this relates to the following issue ?

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9116317-cascading-filter-capabili...

Kind Regards,

Kieran.

[Anonymous · Accepted solution]

@Kieran,

When you change any of the parameters you must apply changes to refresh the list that concatenates them, and then this value is refreshed in the third parameter, but you have to select this refreshed value by displaying the drop down for that parameter.

Regards.