Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filters and sorting issues with data from different languages

We're experiencing issues with databases that has different language data.  We have a Power BI report that was created originally with a PC language set as English but when we're importing data wi...
Need Help
Tips and Tricks
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    I reproduced your scenario, and this problem did occur, but I found a solution, which is simpler than recreating the report.

    You need to create another report(with swedish language model setting) with the field(need to sort), then create a column to sort and publish it to pbi service.

    Like this:

    Column = RANKX('Table',[Column1],[Column1],ASC)

    Secondly, You need to add a powerbi dataset data source to the original report, and then establish a relationship between the two tables, and then use the new table columns and calculated columns in the visual to replace the original one, then you can get the correct order finally.

     

     

    Best Regards

    Janey Guo

     

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

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, Anonymous 

 

I reproduced your scenario, and this problem did occur, but I found a solution, which is simpler than recreating the report.

You need to create another report(with swedish language model setting) with the field(need to sort), then create a column to sort and publish it to pbi service.

Like this:

Column = RANKX('Table',[Column1],[Column1],ASC)

Secondly, You need to add a powerbi dataset data source to the original report, and then establish a relationship between the two tables, and then use the new table columns and calculated columns in the visual to replace the original one, then you can get the correct order finally.

 

 

Best Regards

Janey Guo

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Janey.


    Thank you for your answer. 

    As I understand, I would have to do this for each language and table that I wish to sort.

    This seems almost the same as recreating the report if I understand correctly?

    Regards,
    Jacob

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      5 years ago

      Hi, Anonymous 

       

      If there are many measures and visuals in your table, then my method will save a lot of time. If there is only one visual, then it is almost the same.

      You only need to create and connect the dataset containing that language field and a calculated column, and replace the original language field after create the relationship. 

      The whole process takes only a few minutes. I think this is the only and fast way.

       

      Best Regards

      Janey Guo

       

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