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

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.

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.