Forum Discussion
Text in Table
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.
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?- MFelix5 years agoSuper User
In the first step of the query in the source do you have option to select the regional settings?