Forum Discussion

ldittmann970's avatar
ldittmann970
Advocate III
8 years ago
Solved

Display Unit Formatting

Hello all,   I am wondering if it is possible to correct the current formatting of display units in Power BI.  Currently, I have a report which displays values both in the millions and in the billio...
Need Help
Hardik's avatar
Hardik
Continued Contributor
8 years ago

Format the data in the formatting tab 

ldittmann970's avatar
ldittmann970
Advocate III
8 years ago

To clarify, what I need to format is the display unit label of 'bn' , not my measure or column.  I would like to indicate billions by using a capital 'B' rather than 'bn'

Is there a way in the Modeling toolbar or any other way to edit this? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi ldittmann970,

     

     

    Nope, current you can only use format function to change numeric unit.


    BTW, even if you change the display format, the result is also transformed to text.

    FORMAT Function (DAX)

     

    Regards,

    Xiaoxin Sheng

    • KyleWilliamsBMI's avatar
      KyleWilliamsBMI
      Advocate II
      8 years ago

      To chime in here, what we're struggling with is why Billions shows up as "bn" and why millions shows up as "M". These are not necessarily standard abbreviations for this sort of data. Is there any insight as to why this particular methodology was chosen Anonymous?

    • KyleWilliamsBMI's avatar
      KyleWilliamsBMI
      Advocate II
      8 years ago

      Hi Anonymous can you please review our questions on this ticket and please advise?

    • SchoolEnrollmen's avatar
      SchoolEnrollmen
      Frequent Visitor
      5 years ago

      Good afternoon, 

       

      The display units current set up from None, thousands and up, is there anyway to set up the display in tens, and hundreds? Thanks and please advise!