Forum Discussion
Language preference
I created report in Japanese, which is my first language, and now i have to report in English.
Most of sections are replaced in english by changing language setting (such as "Total" in sum).
However, "pull down slicer" to set the date has not been changed yet. Japanese letters correspond to" Year" and "month" has been remained.
Could you let me know how to change it?
Thank you in advance.
Thank you rohit1991
Hi, ShunTas
First of all, you need to have the Tabular Editor:
https://github.com/TabularEditor/TabularEditor
Open this software:
At this point, we'll need to re-add the fields to the slicer:
If you want to change the name of the hierarchy, you need to go ahead and modify it:
After the above steps, you will be able to correctly modify the language of the date hierarchy of the hierarchy.
Of course, you can open your report file in Power BI desktop, then open the Tabular Editor to modify it, and finally re-upload your PBIX file. This is the recommended approach because it guarantees that your files on Power BI Service won't be affected after the modification.Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
To change slicer labels from Japanese to English in Power BI:
- Rename Fields: In the Fields pane, right-click the column used in the slicer and rename it to English.
- Power Query Editor: Use Transform Data to edit column headers or values from Japanese to English.
- Language Settings: Set the default language to English under File > Options > Regional Settings.
- Update Slicer Title: In the slicer settings, edit the title under Visualizations > Format > Title.
This will update the slicer labels.
Thank you sir.
However, they didn't solve my issue.. here are the result.
Could you provide any other solution if you have?
1.> there isn't "rename" on right click menu
2.> only i could change locale of date. Japanese labels appear to be generated automatically.
3.> Changed. but not resolved
4.>there is no title. title is off.
Thank you rohit1991
Hi, ShunTas
First of all, you need to have the Tabular Editor:
https://github.com/TabularEditor/TabularEditor
Open this software:
At this point, we'll need to re-add the fields to the slicer:
If you want to change the name of the hierarchy, you need to go ahead and modify it:
After the above steps, you will be able to correctly modify the language of the date hierarchy of the hierarchy.
Of course, you can open your report file in Power BI desktop, then open the Tabular Editor to modify it, and finally re-upload your PBIX file. This is the recommended approach because it guarantees that your files on Power BI Service won't be affected after the modification.Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
