SharePoint Dashboard Conditional Indicators
->
Some fellow Dashboard Spies and I were discussing the rising popularity of Microsoft Sharepoint server for executive dashboard applications and the topic of conditional formatting and graphical red/green/yellow status indicators arose. Were dashboard traffic lights available in SharePoint right out-of-the-box?
We found this nice video demonstration of how to tweak the Sharepoint code so that you do get red/green/yellow lights on a simple list:
The Dashboard Spy is all about screengrabs, so I extracted some images for you to take a quick look in case you don’t have time to watch the video right now. Here is the view of the color state images:
And here is a look at the part where he is tweaking the code to make the conditional display logic work:
Tags: Sharepoint Dashboards, Sharepoint dashboard indicators

What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.
5 Responses to “SharePoint Dashboard Conditional Indicators”
Leave a Reply
Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:
- SharePoint 2007 Project Dashboards with Corasworks Web Parts ...
- Microsoft SharePoint 2007 Hard to Skin? ...
- SharePoint Dashboard for Marketing Campaign Tracking ...
- Screenshot of a Performance Evaluation Dashboard from the SharePoint Template Series ...
- Building an Executive Dashboard in Excel 2007 with Conditional Formatting ...
- Security Update Patch Management Dashboard for Monitoring Patch Status ...
- SharePoint Template for a Competitive Intelligence Dashboard ...
- Microsoft Dynamics Dashboard - A CEO Scorecard Example ...
Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?
- Excel Infographics
- iDashboards Winter Olympics Dashboard
- Go Back to School for Excel
- 7 Ways to Remain Relevant for Business Intelligence in 2010
- Dashboard Data Table Navigation
- Dashboard Metrics Status Indicators
- Communicating Through Business Dashboards
- Building a Flex Dashboard
- Retail Store Scorecard
- Google Analytics Marketing Dashboard






[...] I pointed her to several SharePoint Dashboard videos on the dashboard screenshot blog - Dashboards By Example. After we jointly studied a couple more dashboards done in SharePoint, our discussion turned to [...]
You can also use charts to do the same:
http://www.anychart.com/blog/2008/02/04/add-interactive-charts-to-your-microsoft-sharepoint-portal/
Great tutorial, but I have one problem with the result. In one of my columns, I’m using a person’s name, and even though I have the “presence indicator” turned off, once I make these changes in Sharepoint designer, the presence indicator shows back up. When it comes back, it’s on the right side of the name rather than the usual left…
This is a problem because it distracts from the status indicators that were my goal in the first place.
Any advice on how to remove these?
I just came across your article, and wanted to share a method to diplay indicators in SharePoint (2003 or 2007). Here is the link:
http://pathtosharepoint.wordpress.com/2008/09/01/apply-color-coding-to-your-sharepoint-lists/
My method is easier and is entierely applied through the SharePoint UI (no FrontPage or SharePoint Designer).
The following article explains how to configure a Data View Web Part with conditional formatting to allow items in a SharePoint list to be formatted based on item-level meta data, such as the due date or priority of a Task Item. The example formats items in a task list so that overdue tasks are bold and red, tasks due in 3 days are formatted as orange, 1 week yellow and one month green.
See http://blog-sharepoint.blogspot.com/2009/05/data-view-conditional-formatting-using.html for details.
SharePoint Conditional Formatting