Forum Discussion

swapnilklkar's avatar
swapnilklkar
New Member
2 years ago
Solved

How to select columns in PowerBI using a parameter

I have to build a Bilingual powerBI report. In my data, I have both English and French descriptive columns.  In tableau, for e.g. I was able to create a parameter called 'Language and then create a ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi swapnilklkar ,

    I created a sample pbix file(see the attachment) using two different methods, please check if they can help you achieve your requirement.

    1. By creating a field parameter

     

    Language = {
    ("EN", NAMEOF('Table'[PRODUCT_NAME_EN]), 0),
    ("FR", NAMEOF('Table'[PRODUCT_NAME_FR]), 1)
}

     

    2. By creating a Power Query parameter

    Create query parameter

    Create a custom column

    Best Regards 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi swapnilklkar ,

I created a sample pbix file(see the attachment) using two different methods, please check if they can help you achieve your requirement.

1. By creating a field parameter

 

Language = {
    ("EN", NAMEOF('Table'[PRODUCT_NAME_EN]), 0),
    ("FR", NAMEOF('Table'[PRODUCT_NAME_FR]), 1)
}

 

2. By creating a Power Query parameter

Create query parameter

Create a custom column

Best Regards