Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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
User | Count |
---|---|
94 | |
77 | |
71 | |
62 | |
58 |
User | Count |
---|---|
110 | |
103 | |
84 | |
65 | |
62 |