Forum Discussion
Cacaff
Microsoft Employee
10 years agoShowing 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...
- 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.
- 10 years ago
Select the Field and then...
dramus
Continued Contributor
10 years agoClick 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.