Conditional Format on Charts

In this guide, we’ll walk through the steps for applying a highlight rule to a table column, and then we’ll finish with a practical example using the AdventureWorks Data Warehouse.

Step 1: Select the Table

1. In your Wyn dashboard, select the table you want to format.

2. Once selected, the action buttons appear on the right-hand side.

Step 2: Open Conditional Formatting

1. Click the Conditional Formatting button from the action menu.

2. The Conditional Formatting window will open.

Step 3: Configure the Rule

1. In the window, locate the option Set for.

   • Choose the column you want to format (for example, Total Quantity).

2. Next, find the option Based On.

   • Set this to Field Value.

3. Open the dropdown menu for Style.

   • Choose Highlight Cell Rules.

   • From the sub-menu, select Greater Than...

Step 4: Define the Condition

1. In the pop-up window that appears, enter the threshold value for your rule.

   • Example: 1000 (to format all cells greater than 1000).

2. After the word With, choose the style you want to apply.

   • Example: Light Red Fill with Dark Red Text.

3. Click OK to apply the formatting.

Example: Highlighting Quantities Greater than 1000

Here’s a sample query you can use against the AdventureWorksDW data warehouse to produce a table of products and their total sales and quantities:

SELECT TOP 15
    p.ProductKey,
    p.EnglishProductName AS ProductName,
    SUM(f.SalesAmount) AS TotalSalesAmount,
    SUM(f.OrderQuantity) AS TotalQuantity
FROM
    FactResellerSales AS f
JOIN
    DimProduct AS p ON f.ProductKey = p.ProductKey
JOIN
    DimDate AS d ON f.OrderDateKey = d.DateKey
WHERE
    d.CalendarYear = 2013
GROUP BY
    p.ProductKey,
    p.EnglishProductName
ORDER BY
    TotalSalesAmount DESC;

When you apply conditional formatting to the TotalQuantity column and set a rule for values greater than 1000, Wyn will automatically highlight those cells with your chosen style.

For example:

• Any product with a TotalQuantity above 1000 will appear with a light red fill and dark red text, making it easy to spot higher-volume products at a glance.