Hi All
I have a bar chart that is built from 2 sources that have been joined by a unique order number. I do this because I need a date field from that data source.
Everything is going exactly as I want it to except the colours assigned to each Mark are not being sorted together resulting in an ugly chart.
I think i know the way to make them 'sit' together (by putting the dimension or measure at the top of the 'marks' box) but as you can see that is not happening!?!?!?
Any ideas on how to group them? I feel like the aggregation of the secondary data source might be affecting this or that the 'Test to Check' is a measure and 'No.' is a dimension but i am not sure?
Any ideas?
PS i can't shared the data as it is private. : (
Attached is a screen shot - hopefully it can shed some light
Thanks!
Hi, Kevin
Thanks for the workbook.
Please find my workaround attached. below is the screenshot of result. additional line of % is not doable as you use data blending and the option 1 and option 2 is actually based on each order, so it is hard to get it aggregated at week level unfortunately. the only possible way is to join the data rather than blend.
Hope this helps
ZZ
