public Form1()
{
InitializeComponent();
Dashboard dashboard = new Dashboard(); dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml");
dashboardViewer1.Dashboard = dashboard;
GridDashboardItem grid = (GridDashboardItem)dashboard.Items["gridDashboardItem1"];
GridMeasureColumn extendedPrice = (GridMeasureColumn)grid.Columns[1];
extendedPrice.Measure.UniqueId = "extendedPrice";
DashboardParameter priceParameter = new DashboardParameter();
priceParameter.LookUpSettings = null;
priceParameter.Name = "priceParameter";
priceParameter.Type = typeof(decimal);
priceParameter.Value = 150000;
priceParameter.Description = "Format values that are greater than";
dashboard.Parameters.Add(priceParameter);
GridItemFormatRule greaterThanRule = new GridItemFormatRule(extendedPrice);
FormatConditionExpression greaterThanCondition = new FormatConditionExpression();
greaterThanCondition.Expression = "extendedPrice > [Parameters.priceParameter]";
greaterThanCondition.StyleSettings =
new AppearanceSettings(FormatConditionAppearanceType.PaleGreen);
greaterThanRule.ApplyToRow = true;
greaterThanRule.Condition = greaterThanCondition;
grid.FormatRules.AddRange(greaterThanRule);
}
public void AddFormatRulesToScatterChart(ScatterChartDashboardItem scatterChart)
{
double unitCountThreshold = 7000;
double discountThreshold = 18;
ScatterChartItemFormatRule expressionRule1 = new ScatterChartItemFormatRule();
expressionRule1.DataItem = scatterChart.AxisYMeasure;
FormatConditionExpression formatCondition = new FormatConditionExpression();
formatCondition.Expression = $"{scatterChart.AxisYMeasure.UniqueId} > {unitCountThreshold} && {scatterChart.AxisXMeasure.UniqueId} > {discountThreshold}";
formatCondition.StyleSettings = new ColorStyleSettings(ColorTranslator.FromHtml("#14abb7"));
expressionRule1.Condition = formatCondition;
expressionRule1.ShowInLegend = true;
expressionRule1.DisplayName = "Discount amount from the quantity of products sold";
scatterChart.FormatRules.Add(expressionRule1);
ScatterChartConstantLineUserData moduleData = new ScatterChartConstantLineUserData()
{
Enabled = true, VerticalAxisValue = discountThreshold, HorizontalAxisValue = unitCountThreshold
};
scatterChart.CustomProperties.SetValue(ScatterChartConstantLineUserValueModule.PropertyName, moduleData.GetStringFromData());
}
