Skip to Content

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,

 

image

 

The Graph in View Result Mode,

 

image

Please provide your comments.

3 Comments
You must be Logged on to comment or reply to a post.
  • 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.
    • 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.

  • 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.