Percentage values not working correctly

[NLEIGH]

Hi, I am having a problem with % not being recognised correctly.  In Transform data the % to Target looks like this, however when I look at in the Table View it shows the data as 100% against each row.

 

Can anyone help with a solution ?

Many thanks

[v-heq-msft]

Hi @NLEIGH ,
From your description, the percentage values seem to be correct during the data conversion phase, but are not displaying as expected in the table view.
From what I've been learned, sometimes, incorrect relationships in the data model can lead to anomalous aggregation behavior. So, please check the relationships between tables to make sure there are no one-to-many relationships that cause each row to display 100%.
If you are still experiencing problems with the percentage values, a more in-depth investigation may be required. If possible, please provide additional details such as pbix file ,relatinships between these tables or sample data (with sensitive information removed) to help further diagnose the issue.

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[zenisekd]

Can you show, how do you look at it in the table view?
Make sure about the setting of the column:

[NLEIGH]

Hi, please see below my tablet view

[zenisekd]

Check again the column format, as I have advised you. There will be something incorrect...