This is part of the SAP Lumira Discovery blog series.

In Microsoft Excel, conditional formatting quickly highlights important information in a spreadsheet. But sometimes, the built-in formatting rules don’t quite go far enough. Adding your own formula to a conditional formatting rule gives it a power boost to help you do things the built-in rules can’t do.

The motive of Conditional Formatting in SAP Lumira Discovery is to highlight a set of values in the charts, based on the rules defined by the user. The option for formatting is similar to the older version of SAP Lumira, but now it can be extended throughout the storyboard and not be limited to a visualization.
 
Conditional formatting for charts in SAP Lumira Discovery - 1
 
In this dialog we can create, edit ore delete rules. One can also alter the order in which these rules apply or influence the charts. This is similar to the rule editor found in Microsoft prodcuts.
 

Creating a rule

 
Conditional formatting for charts in SAP Lumira Discovery - 2
 
In SAP Lumira Discovery, conditional formatting option is seen in the context menu of the charts.

Below screenshot is taken at Design time-
 
Conditional formatting for charts in SAP Lumira Discovery - 3
 
Whereas, in older versions, it is seen in the menu bar (see below).
 
Conditional formatting for charts in SAP Lumira Discovery - 4
 

Runtime conditional formatting

 
During runtime hover over the chart and click the highlighted option (see below).
 
Conditional formatting for charts in SAP Lumira Discovery - 5
 
This expands the whole menu where we can see “Conditional formatting” option.
 
Conditional formatting for charts in SAP Lumira Discovery - 6
 
Clicking on this opens the Conditional formatting settings dialog (same as design time). Here we can create, disable or switch rules. Runtime conditional formatting is not possible in older version.

The conditional formatting options are not available in few chart types like Tree map, heat map, geo maps, funnel chart etc.

The rules defined in design time will be available for all components i.e rules defined global can be applied to any chart within the application. Let’s say we define a set of rules in design time (from context menu of a chart A), now we will be able to see these defined rules in the Chart B Conditional formatting dialog as well.

Interested to learn how to leverage SAP Lumira for your enterprise (or) train your business users in SAP Lumira Discovery? Reach out to us today.

5600 Tennyson Pkwy
Suite 120
Plano TX 75024.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com