How can I merge two values in a clustered bar chart

[Anonymous]

Hello, 

In the attached below graph, is there any way to merge 'Service+MOT' and 'MOT+Service' as potentially they are the same. But, its a user input which is a bit different in the Column 'Category'.  Thanks

[mahoneypat · Accepted solution]

You can add a Replace Values step in your query to replace one of those category values with the other, so you end up with just one.

Pat