Conditional formatting

[#1]

Hi, is it possible to have multiple charts on a tab and have the max quarter (most recent quarter) show up in a different color

For example: 2010 Q1  -2011 Q4 (all bar charts would show up in blue) and then 2012 Q1 would be in green? 

Thank you

[Anonymous]

Do you also have a Field: Quarter?

[#3]

I have a field called Fiscal Quarter and Year  ex. 2012 Q1 and a field called Fiscal Year  ex. 2012

[Anonymous]

Ok, what happens if you use:

if(Quarter =Max(Total Quarter), blue())

Where the green Quarter is the fieldname of your Quarter

?

[#5]

It still doesn't change the color for me :<

[Anonymous]

Can you share your document here, then I will have a look.

[#7]

Attached is an example copy of what I'm trying to do

[Anonymous]

Hi G.

I found what the problem is. Your formula is right.

But your field is not a number field

I tried this:

=if([Fiscal Year] =Max(Total [Fiscal Year]), red())

And that worked.

[Anonymous]

Try this in your load script

purgechar ( [Fiscal Quarter and Year],'Q' ) as Quarter

And use this field

This will drop the Q from the field so you can count with it.