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 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.

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"

2 Replies

  • 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