5 Replies Latest reply on Aug 16, 2018 6:09 PM by Xiao Wen Song

# Bar Chart with Multiple Measures, Each Using a Different Color Scheme

Hi all,

Hoping for some help here. I have data that looks something like this:

NameScienceMathEnglish
AshleyPlatinumSilverGold
BrianGold SilverSilver
JimSilverNULLNULL
MikeGoldGoldGold
ClarkePlatinumPlatinumGold

I have created calculated fields to count the total # who received awards for each dimension (e.g. IF NOT ISNULL(English), THEN 1) and created a bar chart based on these 3 measures:

I want to be able to apply a color scheme for each Measure based on its Dimension. The problem is that I am not able to apply different color schemes to each row. E.g. below, when I drag the Dimension "English" to the color, it applies to all rows. So the color code for Math and Science here, for instance, is actually dependent on whether that Student got any award for English!

Is there a way to make it such that each row goes according to its own dimension?

Apologies in advance that I haven't posted the workbook because the data is quite sensitive, I know it's not ideal.

• ###### 1. Re: Bar Chart with Multiple Measures, Each Using a Different Color Scheme

Hi,

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.

Mahfooj

• ###### 2. Re: Bar Chart with Multiple Measures, Each Using a Different Color Scheme

Hi Mahfooj,

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.

Sincerely

Xiao Wen

• ###### 3. Re: Bar Chart with Multiple Measures, Each Using a Different Color Scheme

Could you please share some sample mock up in packaged workbook? It'll help us to provide your correct output.

• ###### 4. Re: Bar Chart with Multiple Measures, Each Using a Different Color Scheme

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.

• ###### 5. Re: Bar Chart with Multiple Measures, Each Using a Different Color Scheme

Hi Mahfooj,

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.

Much appreciated,

Xiao Wen