Text in Table

[netanel]

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

[PhilipTreacy]

Hi @netanel 

So the text is displayed correctly then?

regards

Phil

[netanel]

In Query the Data comes from left to right

it matters?
How do you arrange it to right to left?

[V-lianl-msft]

Hi @netanel ,

There is a List.Reverse option in the query editor, maybe you can flip or create a column with flip text so you can use on your visualization.

See if it will help:

https://community.powerbi.com/t5/Desktop/Reverse-Text/td-p/2803 

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

[netanel]

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]

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]

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]

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

[netanel]

Not really understand,
In Excel or in PBI?

In PBI: 

[netanel]

Yes, the problem is only in the signs
: . ?

[PhilipTreacy]

Hi @netanel 

Hebrew is written/read right to left so that is displayed correctly?

regards

Phil

[netanel]

yes, Hebrew is from right to left

And the text is Shown from right to left