Forum Discussion

Gumberculeez's avatar
Gumberculeez
Helper II
4 years ago
Solved

Conditional formatting based on numbers from different columns being different

Hey Guys;

 

Struggling with trying to get some conditional formatting to work.  Here's a sample of my table:

 

What I want to do is conditional format my Shipped column to go red if it doesn't equal my Quantity column.  I'm pulling this in as a direct query, these two columns are from the same table, however, I get seem to get this to work.

Any assist would be fantastic. 🙂

Need Help
  • johncolley's avatar
    johncolley
    4 years ago

    Hi Gumberculeez ,

     

    Create the following measures and use conditionalformatting on the shipped column:

     

     

    quanmeasure = SUM(Shipping[Quantity])
     
    shipmeasure = SUM(Shipping[Shipped])
     
    conditionalformatting = SWITCH(TRUE(),

    [quanmeasure] <> Shipping[shipmeasure], "red", BLANK())

    Replace "Red" with a #xxxxxx code if you want to change the colour.

     

1 Reply

  • johncolley's avatar
    johncolley
    Solution Sage
    4 years ago

    Hi Gumberculeez ,

     

    Create the following measures and use conditionalformatting on the shipped column:

     

     

    quanmeasure = SUM(Shipping[Quantity])
     
    shipmeasure = SUM(Shipping[Shipped])
     
    conditionalformatting = SWITCH(TRUE(),

    [quanmeasure] <> Shipping[shipmeasure], "red", BLANK())

    Replace "Red" with a #xxxxxx code if you want to change the colour.