Profile Picture

Change the color of a bar if value is above 10

Posted By Bob Smith 11 Years Ago
Author
Message
Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1

I realize that this question should have a simple answer, but it seems that the application is more complicated.

I would like to use an "IF" statement to change the fill color of a bar in a bar chart if the sum of "Sales" for an item is above the 10.

To get the value of each item's sum of sales simply FIRST(SUM(Fields!Sum_Of_Sales)). But how do I apply this value into a condition that will change the color of the bar?



Nevron Support
Posted 11 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

Hi Bob,

You can do that from the Pivot >> Data Groupings >> Values >> Appearance. You can Use Custom Data Point Appearance.

The following examples are using conditional Custom Data Point Appearance:

Box And Whiskers Chart

Range Selection Chart

 

You can also review the following Help Documentation topics:
Editors > Property Editors
Editors > Appearance FX Editors > Fill Style FX Editor

Hopefully this helps.



Best Regards,
Nevron Support Team



Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)

Group: Forum Members
Last Active: 11 Years Ago
Posts: 69, Visits: 1

Works great!

This topic was also quite helpful: http://forum.nevron.com/shwmessage.aspx?ForumID=13&MessageID=7456

Thanks!





Similar Topics


Reading This Topic