Skip to Content

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.

To report this post you need to login first.

3 Comments

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

  1. Erika Atencio
    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.
    (0) 
    1. Veeraraghavan Vijayarajan Post author
      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.

      (0) 
  2. Veeraraghavan Vijayarajan Post author
    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.

    (0) 

Leave a Reply