Forum Discussion

jochemd96's avatar
jochemd96
Frequent Visitor
4 years ago
Solved

Using a column based on language

Hello,   I recently started creating PowerBI reports and now I start to get stuck a little. I think I have a fairly easy to solve problem, but I can't get the hang of it.   I have the following d...
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi jochemd96 ,

    You can use a measure like this:

     

    Measure =
IF (
    SELECTEDVALUE ( 'Talen'[Taal] ) = "Nederlands",
    MAX ( 'Display'[DisplayOmschrijving] ),
    MAX ( 'Display'[DisplayDescription] )
)

     

    Then put the column Index and this measure into a visual, it works.

    Here's the difference of calculated column and measure:

    https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

jochemd96 Columns are not dynamic based on user input but are only calculated during load/refresh. I wrote an entire blog series on multi-language support here: 

https://community.powerbi.com/t5/Community-Blog/Localizing-the-Data-Model-Part-1/ba-p/2062997

https://community.powerbi.com/t5/Community-Blog/Localizing-the-Data-Model-Part-2/ba-p/2065547

https://community.powerbi.com/t5/Community-Blog/Localizing-the-Data-Model-Part-3/ba-p/2071522

https://community.powerbi.com/t5/Community-Blog/Localizing-the-Data-Model-Part-4/ba-p/2095284

 

  • jochemd96's avatar
    jochemd96
    Frequent Visitor
    4 years ago

    Thanks, I already suspected such thing. What do you suggest to solve this problem?