Forum Discussion

chotu27's avatar
chotu27
Icon for Post Patron rankPost Patron
8 years ago

X axis values Duplicating in Clustered Column chart

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

Need Help
Show and Tell

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

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

     

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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