Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ShunTas
New Member

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.スクリーンショット 2025-01-02 155255.jpg

1 ACCEPTED SOLUTION
v-jianpeng-msft
Community Support
Community Support

Thank you rohit1991 

Hi, @ShunTas 

First of all, you need to have the Tabular Editor:

https://github.com/TabularEditor/TabularEditor

Tabular Editor 3

Open this software:

vjianpengmsft_0-1736147046552.png

vjianpengmsft_1-1736147106159.png

vjianpengmsft_2-1736147201483.png

vjianpengmsft_3-1736147273323.png

 

vjianpengmsft_5-1736147466050.png

vjianpengmsft_10-1736147820370.png

 

At this point, we'll need to re-add the fields to the slicer:

vjianpengmsft_6-1736147509429.png

vjianpengmsft_7-1736147590299.png

If you want to change the name of the hierarchy, you need to go ahead and modify it:

vjianpengmsft_8-1736147653420.png

vjianpengmsft_9-1736147748020.png

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.

 

 

 

 

 

 

View solution in original post

3 REPLIES 3
v-jianpeng-msft
Community Support
Community Support

Thank you rohit1991 

Hi, @ShunTas 

First of all, you need to have the Tabular Editor:

https://github.com/TabularEditor/TabularEditor

Tabular Editor 3

Open this software:

vjianpengmsft_0-1736147046552.png

vjianpengmsft_1-1736147106159.png

vjianpengmsft_2-1736147201483.png

vjianpengmsft_3-1736147273323.png

 

vjianpengmsft_5-1736147466050.png

vjianpengmsft_10-1736147820370.png

 

At this point, we'll need to re-add the fields to the slicer:

vjianpengmsft_6-1736147509429.png

vjianpengmsft_7-1736147590299.png

If you want to change the name of the hierarchy, you need to go ahead and modify it:

vjianpengmsft_8-1736147653420.png

vjianpengmsft_9-1736147748020.png

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.

 

 

 

 

 

 

ShunTas
New Member

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. 

rohit1991
Super User
Super User

To change slicer labels from Japanese to English in Power BI:

  1. Rename Fields: In the Fields pane, right-click the column used in the slicer and rename it to English.
  2. Power Query Editor: Use Transform Data to edit column headers or values from Japanese to English.
  3. Language Settings: Set the default language to English under File > Options > Regional Settings.
  4. Update Slicer Title: In the slicer settings, edit the title under Visualizations > Format > Title.

This will update the slicer labels.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.