Forum Discussion

Cacaff's avatar
Cacaff
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago
Solved

Showing percentage values in visuals

Hello,   I have a simple excel spreadsheet that I've imported in BI.  I have a column of percentages in my excel sheet (no calculations) that are showing up in BI as either negative numbers or in d...
  • dramus's avatar
    10 years ago

    Click on the field name in the Fields list on the right of the PBI Desktop screen, then select the Modelling ribbon at the top.

     

    You should now see under the Formatting section a percent sign. Select that to get PBI to show a percent sign after your data value. If it's disabled, make sure that the data type is set to a number.

  • Sean's avatar
    Sean
    10 years ago

    Select the Field and then...