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
Did you find this information helpful?
Yes
Comments (0)
How to use Conditional Formatting in OlapGrid

Access denied
