Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I created a grouped bar chart that I need help setting the colors for.
It is a horizontal bar chart, displaying the total amount and absolute value of total amount on the bars for two types of products (A & B). So there are a total of four bars (2 for each product type).
Is it possible to have the bars be set to different colors? I want the bars for each product type to be a different color, with the total amount being darker and absolute value of total amount to be a lighter color. For example:
Product A, Total Amount : dark blue
Product A, Abs Value Total Amount : light blue
Product B, Total Amount : dark purple
Product B, Abs Valie Total Amount : light purple
Hi,
are there only two types of product or N number of products?
If it is only 2 products,
Create 4 master measure in bar chart. (Don't create Dimension)
Master Measure 1: Product A, Total Amount, set color dark blue
Master Measure 2: Product A, Abs Value Total Amount , set color light blue
Master Measure 3: Product B, Total Amount , set color dark purple
Master Measure 4: Product B, Abs Valie Total Amount , set color light purple