Dashboard

    Dashboards By Example Volume 1   From Excel Dashboards to Real-Time Dashboards, these dashboards contain KPIs, metrics, charts, trends and data visualizations. Learn the best practices of enterprise dashboard design by studying the work of your peers on business dashboard implementation teams around the world. Examine their digital dashboards and share your dashboard design tips in return.

For more Business Intelligence Dashboard Examples, use this link to the Dashboard Spy sitemap: Dashboard

Note: Dashboards By Example readers can get these interesting business intelligence dashboard white papers discussing the latest approaches to enterprise dashboards.

Want to connect with the Dashboard Spy? Visit the About The Dashboard Spy page to learn how to connect via LinkedIn.
« GIS Dashboards for an Operations Monitoring Center
User Engagement and Conversion Metrics for Product Marketing Dashboards »

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:

Dashboard light indicators for Sharepoint

And here is a look at the part where he is tweaking the code to make the conditional display logic work:

Sharepoint indicators

Tags: Sharepoint Dashboards, Sharepoint dashboard indicators

Learn how to create Excel dashboards.Excel Dashboard

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”

  1. Web Standard Templates for MS SharePoint « The Dashboard Spy Said on November 9th, 2007 at 8:39 pm quote

    [...] 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 [...]

  2. AnyChart Said on February 4th, 2008 at 3:00 am quote

    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/

  3. Joe Said on July 14th, 2008 at 1:21 am quote

    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?

  4. Christophe Said on November 19th, 2008 at 7:26 am quote

    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).

  5. James - SharePoint Conditional Formatting Said on January 3rd, 2010 at 8:11 pm quote

    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

Leave a Reply




Last Modified: Friday, July 27th, 2007 @ 10:14

This business intelligence dashboard blog entry was posted on Friday, July 27th, 2007 at 10:02 am and is filed under Dashboard Screenshots. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Want to see a different randomly selected business intelligence dashboard example? Click here to view another Digital Dashboard from the Dashboard Spy.

Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:

Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?