PowerBI show duplicate value in visualization page, although raw data don't have any duplicate

[HelloTheSun]

I would like to know why show duplicate "Region" name in Table or Matrix visualizations.

Although raw data don't have any duplicate name of "Region" 

Please help me to solve this issue.

Thank you

[rajendraongole1 · Accepted solution]

Hi @HelloTheSun  - Even if "Region1" appears once in your reference table, it may be associated with multiple records in another table/values in same. thats the reason you are seeing in table view with unique. but when you are trying to add the field in visual level using table or matrix you can get duplicates only by adding other fields in same table.

Try using a Table visual instead of Matrix, or check if removing numerical columns affects duplication.

Hope this helps.

[HelloTheSun]

Thank you very much for your reply

I found the root cause because I sort this field from another column and this column it not uniques.

[GiuseppeMR]

Hi,

A possibile cause could be the presece of a custom sorting.

Have you set up some sorting on this visual ?

[Ashish_Mathur]

Hi,

What happens when you drag a simple count or sum measure to the visual?

[Anonymous]

Hi @HelloTheSun ,

Thanks for both of FarhanJeelani's and rajendraongole1's replies!
And @HelloTheSun , please check whether their replies will help you solve your problem? If solved please accept the reply in this post which you think is helpful as a solution to help more others facing the same problem to find a solution quickly, thank you very much!

Best Regards,
Dino Tao

[FarhanJeelani · Accepted solution]

Hi @HelloTheSun,

Can yopu please share your pbix file?? For now please check below points.

Possible Causes and Solutions

1. Duplicate Values in Combination with Other Columns

• If the Table or Matrix visual includes additional fields (e.g., Head Zone  or Zone Manager), Power BI may display multiple rows for the same Regional_Code because the combinations of these fields are unique.

Solution:

• Check the fields added to the visual. Remove other columns that might be causing the split by creating unique rows for each Regional_Code.

2. Hidden Differences in Regional_Code

• The values might have invisible differences (e.g., extra spaces, case sensitivity, or special characters).

Solution:

• Clean the column using Power Query:
  1. Go to Transform Data > Power Query Editor.
  2. Select the Regional_Code column.
  3. Apply these transformations:
     • Trim: Removes leading/trailing spaces.
     • Clean: Removes non-printable characters.
     • Format All to Lowercase/Uppercase: Standardizes the case.

Please mark this as solution if it helps you. Appreciate Kudos.

[rajendraongole1 · Accepted solution]

Hi @HelloTheSun  - Even if "Region1" appears once in your reference table, it may be associated with multiple records in another table/values in same. thats the reason you are seeing in table view with unique. but when you are trying to add the field in visual level using table or matrix you can get duplicates only by adding other fields in same table.

Try using a Table visual instead of Matrix, or check if removing numerical columns affects duplication.

Hope this helps.