I've written a blog on this. It will give you an idea. You need to create several place holders for each measure and have to used conditional color scheme accordingly. Hope this will help.
Thanks so much for the reply! I've looked at the conditional formatting posts and they are helpful - your blog is also very clear. However I am not getting it to work with bar charts - are you aware if the technique will also work with bar charts?
Screenshot 1: Following your instructions in the blog post for text:
Screenshot 2 & 3: Changing it to bar doesn't seem to work, probably because bar chart would need it to be in a column or row
Thanks again for your help, it's much appreciated.
Could you please share some sample mock up in packaged workbook? It'll help us to provide your correct output.
I guess in your case you don't need to create any place holders. You should use Schedule measure at first place in columns shelf. If you can share some sample data with complete structure which matches with your original with expected output then I can help.
Thanks so much for the help! Please find attached a sample workbook with exactly the same data structure. If one looks at the "Accreditation Bar Chart" worksheet - that is the bar chart I want to color based on different dimension names.
Background - each Entity may have multiple kinds of accreditation, e.g. in Environmental Impact, in Recylability, in Sustainability. Entities may have multiple rows because they are located in multiple locations. The Bar Chart shows the number of accreditations in each State, by type of accreditation. I want to be able to color each Bar based on the associated Dimension (e.g. if the bar counts accreditation for Environmental Impact, I want to color it based on the Dimension for Environmental Impact - so the bar will show 3 Platinum, 2 Gold, 1 Silver for Environmental Impact.).
Not too sure if it's possible to be honest but hopefully there's some workaround.