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
dramus
Icon for Continued Contributor rankContinued Contributor
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
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Select the Field and then... 

    • ndna74's avatar
      ndna74
      Frequent Visitor
      9 years ago

      Hi

       

      Do you know why this functionality in the "modelling" tab and not in edit queries ?

       

      Thanks

      Nick

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

    Thanks very much for both responses!!!