DevExpress Dashboard - Conditional Formatting (Coming soon in v15.1)

18 May 2015

As you may already know, DevExpress Dashboard - our fully configurable and royalty free Dashboard platform for Windows & the Web - ships as part of our Universal Subscription. If you've not yet had the chance to review it's capabilities, please take a moment to download our free 30 day trial and let us know what you think...

What's Coming in v15

Among the new features we'll introduce in our upcoming release of the DevExpress Dashboard is the ability to apply Excel-like conditional formatting to individual Grid & Pivot Table dashboard items. This feature allows you to highlight specific cells or entire rows using a predefined set of rules.

DevExpress Dashboard Conditional Formatting - Pivot Grid

Comparison rules used for formatting can be divided into the following groups.

  • Value - Allows you to compare static values (such as Greater Than, Less Than, Date Occurring, etc.) or specify a desired criteria in the Expression Editor. You can also pass dashboard parameters to the expression.
  • Top/Bottom - Highlights a specific number of topmost/bottommost values.
  • Average - Highlights cells with values above or below an average.
  • Range - Allows you to apply formatting by specifying a multiple range of values. You can change the number of ranges and select whether to use color or icon ranges.

The Dashboard Designer will ship with the ability to apply format rules to dashboard measures and dimensions. Conditional formatting allows you to modify cell backgrounds, font settings or display specific icons in cells that meet the specified criteria.

With that brief introduction to comparison rules, let's take a look at a few screenshot that illustrate the new features coming your way in v15.1.

Specifying Multiple Format Rules for a Grid 

DevExpress Dashboard - Conditional Formatting

Conditional Formatting - Top N Dialog Window

DevExpress Dashboard Conditional Formatting TopN Values

Conditional Formatting - Color Ranges

DevExpress Dashboard Conditional Formatting Color Range

Conditional Formatting - Color Range Set

DevExpress Conditional Formatting Color Range Set

Conditional Formatting - Editing Rules

DevExpress Dashboard Conditional Formatting - Editing Rules

DevExpress Dashboard makes it easy to edit rules. The Edit Rules dialog displays all rules created for the selected dashboard item. Note that existing rules can be filtered by the required measure or dimension.

Conditional Formatting - Expression Editor

DevExpress Dashboard Expression Editor

With the Expression Editor, you can:

  • Specify the expression used to format values based upon parameter values.
  • Select the required color in the Appearance tab.

Conditional Formatting - Parameters

DevExpress Dashboard Conditional Formatting Parameters

Easily change parameter values as requirements dictate.

So that's a brief overview of Conditional Formatting within the DevExpress Dashboard. We'd love to hear your feedback. Let us know what you think.

10 comment(s)
Jonatas Hudler

Great addition! Will be so helpful! Thanks!

18 May, 2015
Leo Li 8

Is this a WinFrom component or a WPF component?

18 May, 2015
Scott G Blood

This has now made this product very usable in a corporate environment and I look forward to playing with it now.

Please tell me the XtraPivotGrid is going to introduce this as well :)

19 May, 2015
Hedi Guizani

Great feature, can wait to see more :)

19 May, 2015
Maxime Savard 3

Good feature

Can you add too indexed position color ?

Example: index mod 2, that ca create alternate color

19 May, 2015
Stefan Koell

Are you also planning in bringing those features to the GridControl?

19 May, 2015
Santi Mas


19 May, 2015
Chris W.

Really cool

19 May, 2015
Paul P (DevExpress)

Thanks a lot for your feedback!

@Leo Li 8: This is Dashboard Designer for WinForms. Dashboard is included into Universal Subscription.

@Scott G Blood: XtraPivotGrid already has Conditional Formatting feature since 14.2:

Would you please clarify your suggestion?

@Maxime Savard 3: Please create a separate ticket in our Support Center and describe a scenario where you wish to implement it.

@Stefan Koell: XtraGrid already has Conditional Formatting feature since 14.2:

Can you please describe your suggestion in detail?

20 May, 2015


20 May, 2015

Please login or register to post comments.