Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

How to display numbers with two decimal places

  • 1.  How to display numbers with two decimal places

    Gold Contributor
    Posted 4 days ago
    Hi,

    How can I display numbers of this column with 2 decimal places? (see screenshot)
    For example : 17,5 => 17,50
                              10 => 10,00
    The Transform / Data Type: Fixed decimal number doesn't work
    Thanks


    ------------------------------
    Gérard Ducouret
    ------------------------------
    Conference-PBI_200x200


  • 2.  RE: How to display numbers with two decimal places

    Posted 4 days ago
    Have you looked in "modelling" and/or the formatting of the table in the visualisation?

    ------------------------------
    Spen
    ------------------------------

    Conference-PBI_200x200


  • 3.  RE: How to display numbers with two decimal places

    Gold Contributor
    Posted 4 days ago
    Hi Spencer,

    The Modeling / Formatting menu and the Field Formatting / Value decimal places are both grayed out: No other choice than Auto.
    Any idea?
    Thanks


    ------------------------------
    Gérard Ducouret
    ------------------------------

    Conference-PBI_200x200


  • 4.  RE: How to display numbers with two decimal places

    Top Contributor
    Posted 4 days ago
    Gerard,

    There is another place to do this!
    This piece controls the displayed format, unless you override it with a setting at the visual level.

    So Modeling tab:
    Format drop down will let you pick formats for dates and such.
    But when you pick a decimal type, you have the Currency, Percent, Thousands separator (comma), and decimal places format options.

    Data Type drop down allows you to change the data type, just like you can in Query Editor.
    Format drop down - depends on what data type you have. This is where you can select a specific format for dates, for example.
    Currency drop down allows you to choose a currency symbol, like the dollar sign in the US, or Euro symbol in Europe.
    Clicking the percent icon, formats with a % symbol. Ex. It would change a value of .10 to 10%.
    Clicking the "Comma" icon with either add/remove the thousands separator (comma in USA, dot in Europe)
    And of course the Decimal Place icon has up and down arrows to increase or decrease the number of decimal places displayed.




    ------------------------------
    Audrey Abbey
    SR. BI Developer/Analyst
    LeapFrogBI
    Portland OR
    ------------------------------

    Conference-PBI_200x200


  • 5.  RE: How to display numbers with two decimal places

    Gold Contributor
    Posted 3 days ago
    Audrey,

    Thanks a lot for these detailed explanations!!!

    Gérard

    ------------------------------
    Gérard Ducouret
    ------------------------------

    Conference-PBI_200x200


  • 6.  RE: How to display numbers with two decimal places

    Bronze Contributor
    Posted 3 days ago
    Hi Gerard -

    I believe you would just need to click on the field in the Fields pane and then the values in the modelling tab will not be grayed out



    ------------------------------
    christopher majka
    Manager, Business Intelligence
    4018682000
    ------------------------------

    Conference-PBI_200x200


  • 7.  RE: How to display numbers with two decimal places

    Gold Contributor
    Posted 3 days ago
    Thanks Christopher,

    That works!

    Gérard

    ------------------------------
    Gérard Ducouret
    ------------------------------

    Conference-PBI_200x200