Illuminate BI Tool Guide
  • Introduction
  • Example BI Reports
  • What is BI Reporting in Illuminate?
  • Getting Started Using BI with Custom Reports
    • Setup Jaspersoft Studio
    • Prepare Your Data Set
    • Create a Basic Jasper Report
    • Publish My Report to Illuminate
    • Edit Report After Publishing
    • Display Selected Filters on Your Report
  • Get Started Using BI with SQL
    • Access Data Via ODBC Connection
    • Learn the Schema
    • Setup Jaspersoft Studio for SQL
    • Create a Basic Report with SQL
    • Publish My Report (SQL Method)
    • Adding Input Controls
  • Tutorials
    • Tutorials for Free Version ("Community Edition")
      • Tutorial 1: Categorize and Aggregate Your Data
      • Tutorial 2: Using Jasper Report Bands
      • Tutorial 3: Student Roster Report
      • Tutorial 4: Student Roster with SQL
      • Tutorial 5: Summary of Performance
      • Tutorial 6: CELDT Longitudinal Summary
    • Tutorials for Pro Version ("Professional Edition")
      • Tutorial 1: Aggregate and Visualize Your Data
        • Step 1 - Create a Custom Report
        • Step 2 - Download Your Data
        • Step 3 - Create a Data Adapter
        • Step 4 - Duplicate Template. Link Data Adapter
        • Step 5 - Set Class for Numeric Fields
        • Step 6 - Add & Configure Chart
        • Step 7 - Resize Chart. Preview Report.
        • Step 8 - Change Chart Labels
        • Step 9 - Set Chart Colors
        • Step 10 - Repeat for Other Data Points
        • Step 11- Install Your Report
      • Tutorial 2: Using Report Bands
        • Step 1 - Duplicate Report from Tutorial 1
        • Step 2: Create Your Group
        • Step 3: Create a Sort Field
        • Step 4 - Copy & Paste Your Chart
        • Step 5 - Set Reset Type and Evaluation Time
        • Step 6 - Change the Category Level
        • Step 7 - Add Site Name Field
        • Step 8 - Grade Level Sorting
    • CrossTabs Tutorial - Create, Format, and Style a CrossTab
      • Step 1 - Create Your CrossTab
      • Step 2 - Size and Position Your CrossTab
      • Step 3 - Format and Style Your CrossTab
  • Homework 1 - BI Workshop Follow Up
  • BI Tool Cheat Sheet
  • JasperSoft Studio Tips, Tricks, & FAQs
    • Basics of Writing Expressions in JSS
    • Rounding Decimals
    • Working with Dates in JSS
    • Conditional Styling in JasperSoft
    • Custom "No Data" Message
    • Create Multiple Summary Bands
    • Create Hyperlinks or "Tabs" to Connect Sets of Reports
    • JSS Community Edition
      • Adding Data Labels to Your Chart
      • Customizing Colors in Your Charts
    • JSS Professional Edition Only
      • HTML5 Charts
        • Data Labels: Enable, Customize, & Round Data Labels
        • Tooltip: Customizing the Tooltip
        • Keeping Colors Consistent in HTML5 Charts
        • Adding Drill Down to a Chart
        • Prevent Tooltip from Being Cut Off
        • Sort the Bars in Your Stack - Ordering the Series in Your Chart
        • Passing Parameters/Data Between Datasets with HTML5 Charts
        • Add Plot Lines to your Chart
        • Add Colored Zones or Plot Bands to Your Chart
        • Change Bar Colors Based on Bar Value
    • Rolling Over Your BI Tool Reports
    • "Current" Columns in Custom Reporting - To Use or Not to Use?
  • Report Design Best Practices
  • Installing the Illuminate Font Set
  • Report Templates
    • Blank Templates - Report Starters
    • Using the Report Templates
    • Multiple Measures Site Comparison Report (Tutorial 5)
    • EL Reclassification Report
    • EL Reclassification Report v2
    • RFEP Monitoring Report
    • Student Rubric Template
    • Michigan Report Templates
      • PSAT and SAT College Readiness Report
  • BI Tool User Community
Powered by GitBook
On this page
  • Step 9 - Set Chart Colors
  • Setting Your Chart's Colors, The Right Way
  • Get HEX Codes
  • Create "color" Bucket Property
  • Set Advanced Property

Was this helpful?

  1. Tutorials
  2. Tutorials for Pro Version ("Professional Edition")
  3. Tutorial 1: Aggregate and Visualize Your Data

Step 9 - Set Chart Colors

PreviousStep 8 - Change Chart LabelsNextStep 10 - Repeat for Other Data Points

Last updated 5 years ago

Was this helpful?

Tutorial 1 for Pro Version: Aggregate and Visualize Your Data

Step 9 - Set Chart Colors

Although there is a very quick, easy way to set your chart's colors using the "Color Palette" feature, it is best practice to tie your chart's colors to the chart's series levels. Otherwise, you could end up with something like this:

If you cut corners, your colors will get misaligned when the report is run for a dataset in which not all your chart's series/performance levels are represented.

Setting Your Chart's Colors, The Right Way

We will use Bucket Properties to set the chart's colors, just like we did to set the chart's labels in Step 8. It's almost the exact same process we completed in Step 8.

Get HEX Codes

To start, you'll want to get the HEX codes for the colors you want to use.

Red: #C13D3D
Yellow: #F5D82A
Green: #1CB931
Blue: #368DD9
Gray: #C9C9C9

Create "color" Bucket Property

  • Double-click on your chart

  • Click Chart Data > Configuration

  • Double-click on the Series Levels you created

  • Click Bucket Properties

  • Click Add

  • Set Property name to "color"

  • Click on the Pencil Icon to bring up the Expression Editor

  • Enter the following expression:

$F{2016-2017 SBA Summative (Final) ELA Performance Level}==null
    ? "#C9C9C9"
$F{2016-2017 SBA Summative (Final) ELA Performance Level}==1
    ? "#C13D3D"
:$F{2016-2017 SBA Summative (Final) ELA Performance Level}==2
    ? "#F5D82A"
:$F{2016-2017 SBA Summative (Final) ELA Performance Level}==3
    ? "#1CB931"
:$F{2016-2017 SBA Summative (Final) ELA Performance Level}==4
    ? "#368DD9"
:"black"
  • Click Finish

Set Advanced Property

Whenever you create a bucket property, you need to pass the property to a measure.

  • Double-click on the Measure you created

  • Click Advanced Properties

  • Click Add

  • Set Contributor to "SeriesProperty" (Use drop down menu)

  • Set Property name to "color" (all lowercase, the property name is case sensitive)

  • Select Use Bucket Value

  • Select the "color" Bucket Property you just created

  • Click OK

Now, preview your report. The chart's colors have now been customized.

Or, use these Hex codes if you don't want to bother picking colors right now:

Refer to for detailed documentation on writing expressions in JSS.

Use this color picker tool to get the hex codes for whatever colors you want.
Basics of Writing Expressions in JSS
>> Continue to Step 10. >>