Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Formatting Number

Hi All, This is my first post to Power BI, I am looking for formattng numbers I have a column called metrics which has mixed type of values  Metrics Value Orders 2.00 Revenue 10.76 ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Anonymous,


    If you setting 'date type' option to decimal number, format option to general; decimal places to auto, power bi will auto hide the decimal part of whole number.

     

     

    Regards,

    Xiaoxin Sheng

alena2k's avatar
alena2k
Resolver IV
8 years ago

 

Please look under Modeling in Desktop as shown above or you can set type on column in Query Editor.