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.