Web Intelligence Bar Graph – How to apply different colours for a single measure?

Recently, we have received a requirement from a customer to display Bar graph in Web Intelligence with different colours for each group (Say Region),but interestingly using a single measure (Say Sales). Bar Graph can show the measure value only in a single color for a measure.

However, we can make it by splitting the measure value into multiple measure using formulas for each group. 🙂

Sample Formula :

=If([Sales Org] = “Ontario” ; [Avg Weekly Opportunity]; 0)

This is how the structure of the Bar Graph looks like,

The Graph in View Result Mode,

Please provide your comments.

3 Comments

You must be Logged on to comment or reply to a post.

Former Member

December 12, 2011 at 5:46 am

although it would mean that you have to create a measure for each city... what if there were new cities? I think that would require the user to modify the report to create new measures.

Former Member

Blog Post Author

December 12, 2011 at 9:46 pm

Hi Erika,

Thanks for reading the blog and your comments. I agree with you completely.

The trick works well with fixed dimensions. However, we need to modify the report if we may have any new values.

Former Member

Blog Post Author

December 12, 2011 at 9:46 pm

Hi Erika,

Thanks for reading the blog and your comments. I agree with you completely.

The trick works well with fixed dimensions. However, we need to modify the report if we may have any new values.

Web Intelligence Bar Graph – How to apply different colours for a single measure?

Assigned Tags