Skip to main content
Solved

Changing Dashboard Bar Chart colors


claudematherne24
Jr Varsity III
Forum|alt.badge.img

I’ve looked at the articles about this process, but still not getting the results I am looking for.  

 

I have a Bar Chart that looks like this:

The values are based on a Attribute filed on the Stock Items.  Values are Medium, Low and High.

In the Color option of the Series, I have the following formula based on the documentation.

=Switch(Value = 'High', '#AB400C', Value = 'Medium', '#e9e00', Value = 'Low', '#a9d360')

But the results are this:

Any ideas?

Best answer by miguel80

I’m guessing that you’re using the description of the Attribute and not the value. Is it a combo?

 

If it is, then you should tru to use the Value. Hope this works.

View original
Did this topic help you find an answer to your question?

4 replies

miguel80
Semi-Pro II
Forum|alt.badge.img+1
  • Semi-Pro II
  • 71 replies
  • Answer
  • November 5, 2023

I’m guessing that you’re using the description of the Attribute and not the value. Is it a combo?

 

If it is, then you should tru to use the Value. Hope this works.


claudematherne24
Jr Varsity III
Forum|alt.badge.img

When you say use the Value, and my attribute is set up like the following:

 

ValueId = 1, Description  = Low

 

I should change my Switch statement to be:

=Switch(Value = '1', '#AB400C', Value = ‘2', '#e9e00', Value = '3', '#a9d360')

 

That did not work either.


claudematherne24
Jr Varsity III
Forum|alt.badge.img

And my Attributes are set as Combo


claudematherne24
Jr Varsity III
Forum|alt.badge.img

After stepping away for a couple of days, I figured out I needed to use “Display Value” as that was how my GI was built to reference the attribute.

 

Thanks for the help.  Once I allowed my mind to clear, it made sense.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings