Percentage data type not working on visuals

[cguarisco]

Hi, I am having some issues at showing percentage data types in tables. The same procedure I've used weeks ago is not working anymore.

Here the steps I've followed:

1. Add a new dataset from MySQL with a column calculated as 1/3. Right click on the dataset -> Edit Query

2. Right click on Column -> Change Type -> Percentage

3. At this moment, in the Power Query Editor window, the data is shown as percentage correctly

4. Close & Apply

5. Select Table visual

6. Add the selected Column as a Field

7. The column now shows 0,67

Am i doing something wrong?

Also, I have a previously created .pbix with a column that is shown correctly on Table visual. If i duplicate the column in the dataset, change type to Percentage.Type, Close&Apply and add both columns to visual -> the newly created column is shown as a decimal number, while the old one is correctly shown as percentage

[v-shex-msft · Accepted solution]

Hello @cguarisco,

There's nothing wrong with your operation.
AFAIK, the current tables in the power bi data model do not support the percentage type. If you set these fields in percentage on the edit side of the query, you will force the transformation to decimal type when they are converted to a data mode table field.

You can click the 'format' tab 'percentage' icon to set the display format of the field value to percentage.

Best regards

Xiaoxin Sheng