Category / Section
How to use Conditional Formatting in OlapGrid
1 min read
In SSAS we can modify the cells font and background color based on the cell’s value. This is like conditional formatting. This can be achieved by using following code snippet.
XAML
<olapgrid:OlapGrid Margin="5,5,5,5" Name="olapgrid1" HorizontalAlignment="Stretch" VerticalAlignment="Stretch" ShowValueCellToolTip="False" ShowHeaderCellsToolTip="True" OlapDataManager="{Binding GridDataManager}" ShowConditionalFormats="{Binding ElementName=chkBoxConditionalFormats, Path=IsChecked}"> <olapgrid:OlapGrid.ConditionalFormats> <olapgrid:OlapGridDataConditionalFormat Name="C1"> <olapgrid:OlapGridDataConditionalFormat.CellStyle> <olapgrid:OlapGridCellStyle Background="LawnGreen" FontFamily="Calibri" FontSize="12" /> </olapgrid:OlapGridDataConditionalFormat.CellStyle> <olapgrid:OlapGridDataConditionalFormat.Conditions> <olapgrid:OlapGridDataCondition ConditionType="GreaterThan" Value="7500000" MeasureElement="Internet Sales Amount" PredicateType="And"/> </olapgrid:OlapGridDataConditionalFormat.Conditions> </olapgrid:OlapGridDataConditionalFormat> <olapgrid:OlapGridDataConditionalFormat Name="C2"> <olapgrid:OlapGridDataConditionalFormat.CellStyle> <olapgrid:OlapGridCellStyle Background="Yellow" FontFamily="Calibri" FontSize="12"/> </olapgrid:OlapGridDataConditionalFormat.CellStyle> <olapgrid:OlapGridDataConditionalFormat.Conditions> <olapgrid:OlapGridDataCondition ConditionType="GreaterThan" Value="200000" MeasureElement="Internet Sales Amount" PredicateType="And"/> <olapgrid:OlapGridDataCondition ConditionType="LessThan" Value="400000" MeasureElement="Internet Sales Amount" PredicateType="And"/> </olapgrid:OlapGridDataConditionalFormat.Conditions> </olapgrid:OlapGridDataConditionalFormat> <olapgrid:OlapGridDataConditionalFormat Name="C3"> <olapgrid:OlapGridDataConditionalFormat.CellStyle> <olapgrid:OlapGridCellStyle Background="Red" FontFamily="Calibri" FontSize="12"/> </olapgrid:OlapGridDataConditionalFormat.CellStyle> <olapgrid:OlapGridDataConditionalFormat.Conditions> <olapgrid:OlapGridDataCondition ConditionType="LessThan" Value="2000" MeasureElement="Internet Sales Amount" PredicateType="And"/> </olapgrid:OlapGridDataConditionalFormat.Conditions> </olapgrid:OlapGridDataConditionalFormat> </olapgrid:OlapGrid.ConditionalFormats> </olapgrid:OlapGrid>
Figure: OlapGrid with Conditional Formats