Skip to main content

    Power BI

    New

    I want to choose to display numbers in English (Milion) or Japanese (百万) after Japanese Yen Mark.

    Vote (11) Share
    Masumi Baba's profile image

    Masumi Baba on 22 Nov 2022 08:24:30

    I want to choose to display numbers in English (Milion) or Japanese (百万) after Japanese Yen Mark.

    Comments (2)
    Masumi Baba's profile image Profile Picture

    Stark Sarah on 13 Aug 2024 06:50:02

    RE: I want to choose to display numbers in English (Milion) or Japanese (百万) after Japanese Yen Mark.

    oh yes, big problem here as wellYou can chose Japanese counters in the visuals, but then in the visual, it's all displayed in English.My current workaround is the below, but it's exhausting to have to think of that again and again...百万円単位 = FORMAT(SUM('YourTable'[Amount]) / 1000000, "#,##0.00") & " 百万円"万円単位 = FORMAT(SUM('YourTable'[Amount]) / 10000, "#,##0.00") & " 万円"

    Masumi Baba's profile image Profile Picture

    Nagano, Noriaki on 25 Nov 2022 01:50:15

    RE: I want to choose to display numbers in English (Milion) or Japanese (百万) after Japanese Yen Mark.

    It is an excellent idea to help us to change the display numbers for localization. Some cases combine English and Japanese reports, so if we can manage it ourselves, it's wonderful.