X axis values Duplicating in Clustered Column chart

[chotu27]

Hi ,

My axis values are duplicating in X axis for clustered column chart . When i choose seetings as Categorical view for X axis Can you please help

[v-caliao-msft]

@chotu27,

What's your X axis column data type? Are there any space in your data? You could use TRIM function which remove all spaces from text except for single spaces between words. And then try it again.

https://msdn.microsoft.com/en-us/library/ee634558.aspx

If this is not what you want, please provide us more information about your report, so that we can make further analysis. You can upload a pbix file to Onedrive or any web storage and share the link. Do mask sensitive data before uploading.

Regards,
Charlie Liao

[parry2k]

What column you have on x axis, how about if you convert it to table, do you see duplicate value?