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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
phamxuanquyen
Employee
Employee

How to display units of measure in power bi reports in Japanese (ex: M→"百万")

Hi,


I have a Power BI desktop report that I have created 

I wants to convert the display units "M" in Power BI reports to the Japanese display units "百万".

 

Detailed images are shown in the attached image below

convert units.png
Any assistance would be greatly appreciated.


2 REPLIES 2
vicky_
Super User
Super User

First step would be to change the currency to yen. You can select your measure / field and then format as currency. Click on the down-arrow next to "$".

vicky__0-1670302952801.png

and then you can change the display units to millions in the format visuals section.

vicky__1-1670303006633.png

 

Hi Vicky, Thanks for the response!

I have carried out the procedure you taught me, but was unable to do so.

 

Specifically, the Japanese yen is displayed with a "¥" mark in front of the numerical value and the unit is still "M".

 

Please see the attached image for details.

convert units2.png

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.