Forum Discussion
remove gap between clustered column chart
Please use this dummy file on Google Drive
Hi saipawar
Data looks in good format already, can you share the dummy pbix file where you are having axis issue.
- saipawar4 years agoHelper IV
Looks like there is a special character (?) at the end of 'Plan' items. Is there a way to remove those? I have trimmed and cleaned that data column but still getting the same error.
Thanks
- mhossain4 years agoSolution Sage
saipawar see this blog https://xlncad.com/remove-or-extract-special-characters-from-a-data-set-using-power-query/
to clean
- v-easonf-msft4 years agoCommunity Support
Hi, saipawar
You can replace the special character (?) with “” to trim and clean the data colum.
If I understand correctly, you can try 'new group' to combine 'Events' and 'Paid Medium Campaigns'. Then replace the original field "status" with this "new group" field in the matrix legend.
Best Regards,
Community Support Team _ Eason