Forum Discussion
Text in Table
In Query the Data comes from left to right
it matters?
How do you arrange it to right to left?
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.
- netanel5 years agoPost Prodigy
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 -
- MFelix5 years agoSuper User
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.
- netanel5 years agoPost Prodigy
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?