Forum Discussion

dzilupl's avatar
dzilupl
New Member
9 years ago
Solved

Parameter - show another description than value

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 ha...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    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"
MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

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's avatar
    dzilupl
    New Member
    9 years ago

    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