Forum Discussion

netanel's avatar
netanel
Post Prodigy
5 years ago

Text in Table

Hello everyone, I have a problem with the table All the Hebrew text is inverted That is, on the other side of the sentence Is there anything that can be done if it?   Thank you  
Need Help
netanel's avatar
netanel
Post Prodigy
5 years ago

Hi thanks V-lianl-msft!


It's a really good direction and I sat on it and tried but unfortunately I did not find an M function suits me ...

 

I want the text to go like this "?האם זה מתאים לי" and not like that "האם זה מתאים לי?"

same whit : and . and -

MFelix's avatar
MFelix
Super User
5 years ago

Hi netanel ,

 

What is the datasource you are using an excel, SQL, CSV?

 

Sometime ago I had an issue because all the number formats where incorrect and the dot was used has a decimal instead of the comma, when I reviewed my file I found nothing incorrect because the regional settings were in my local region, then when I went back to the steps I saw that the file was being upload with US settings so it forced the regional settings to that specific query, and the additional steps inherith.

 

Check if forcing the regional setting hebrew on your datasource step works for what you need. 

  • netanel's avatar
    netanel
    Post Prodigy
    5 years ago

    Hi thanks for the reply,
    My data source is Excel
    I changed the settings in it to be according to the Hebrew language and I brought back the data and the problem repeats itself again.
    Did you mean the settings in Excel to change to hebrew, right?

    • MFelix's avatar
      MFelix
      Super User
      5 years ago

      In the first step of the query in the source do you have option to select the regional settings? 

      • netanel's avatar
        netanel
        Post Prodigy
        5 years ago

        Not really understand,
        In Excel or in PBI?

        In PBI: