Change the color of a bar if value is above 10


Author
Message
Bob Smith
Bob Smith
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
Posts: 69, Visits: 1

Works great!

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

Thanks!


Nevron Support
Nevron Support
Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)
Group: Administrators
Posts: 3.1K, Visits: 4.2K

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
Bob Smith
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
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?


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search