Parameter - show another description than value

[dzilupl]

Is there any possibility in Power BI Desktop to use another description to parameter value?

For example I have parameters like A,B,C,D which have thier names like in this table:

Now I have simple table with Date, Value and Region where Region is connected with my parameter

Region can by only one ore more than one (like 2 last record on 29.05.2017). I'm filtering rows with parameter and this works ok but I want to give the person who will use this report possibility to choose parameters not like A,B,C,D but like "Region 1", "Region 45",  "Region 67", "Region 124". This is only simple example data to show what I need.

This is only simple example data to show what I need.

[MarcelBeug · Accepted solution]

Already available, tables:

- Parameters
- SimpleTable

Create a list ParameterDescriptions:

= Parameters[Parameter description]

Create a parameter Region:

Create a query Parameter:

let
    Source = Parameters,
    #"Filtered Rows" = Table.SelectRows(Source, each [Parameter description] = Region),
    #"Parameter value" = #"Filtered Rows"{0}[Parameter value]
in
    #"Parameter value"

Create a query Result:

let
    Source = SimpleTable,
    #"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([Region], Parameter))
in
    #"Filtered Rows"

[dzilupl]

Thanks! That works as I wanted.

I see that I have to learn a lot about Power BI and how to build advanced queries. I have to look for some good and fast tutorials