Color Expressions in SSAS Calculations

Bradley Schacht

Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Administration". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as and an active member of the Jacksonville SQL Server User Group (JSSUG).

You may also like...

5 Responses

  1. Lisa says:

    I enjoyed your SSIS 2012 for Beginners webinar, thanks

    • I’m glad you enjoyed the webinar. I’ll be posting the questions people had that I didn’t have time to answer at the end sometime this week, so be on the lookout. Also have a bunch of new content I’m going to be posting over the next few weeks. I’ve been a slacker lately and haven’t posted in a while.

  2. Colin Graham says:

    Hello Bradley,
    I’ve been trying to assign some colors dynamically but can’t seem to get it to work, Essentially what I’m trying to do is to determine the colour based on the value of another meaure e.g.
    IIF([Measures].[OHCount] > 0, [Measures].[OnHold Color], 0)
    When I use this in a Calculation it parses and processes just fine,but just shows the result in black.
    Is it actually possible to do what I’m trying to do?

  3. Ansis Kalcenaus says:

    It works with FORE_COLOR but not with BACK_COLOR, even simple numeric expression . I’m using Excel 2016. Not supported?

  4. Mark Gregory says:

    Hi, great article, I was curious, is there a way to have subtotals and grand totals a different color. IE: I have a report where we have the time in the x axis, past values are one color and future is another. Is there more information dimensional coloring with subtotals, etc.

Leave a Reply