Forum Discussion

kdanielv's avatar
kdanielv
New Member
2 years ago
Solved

Conditional formatting a percentage based on other column

Hi forum,   I've been trying to do some color formatting on a matrix. I have a Std and Real values on columns like this   What I'm looking for is to color format the column 'Real' based on ...
Need Help
  • FromZero2BIHero's avatar
    FromZero2BIHero
    2 years ago

    I think if you could provide a sample of your data set would be helpful.

    Especially since I can't see how you could have two columns with the same name in Power BI.

    Later edit: Try to create two separate measures, 1 for Real% January and one for Real% February. Maybe it will work.

kdanielv's avatar
kdanielv
New Member
2 years ago

My bad, I used the wrong symbol and just edited my post. 

 

Either way, I think that what I'm saying on the formula is: 

Color = IF ( MAX ( 'Table'[REAL_%]) < MAX ('Table'[STD_%]), "Green", "Red")

 

If the maximum value in the column 'Real_%' is less than the maximum value in the column 'Std_%', then the condition is true and it returns a Green color, otherwise, Red.

 

Something like this excel that I have here:

 

 

FromZero2BIHero's avatar
FromZero2BIHero
Frequent Visitor
2 years ago

Why not use this instead:

Colour =
 
SWITCH(
    TRUE(),
    MAX('Table'[REAL_%])<MAX('Table'[STD_%), "GREEN",
    "RED")
  • kdanielv's avatar
    kdanielv
    New Member
    2 years ago

    I tried with your formula and is giving me the same result. Not quite sure what's going on.

     

     

    • FromZero2BIHero's avatar
      FromZero2BIHero
      Frequent Visitor
      2 years ago

      I think if you could provide a sample of your data set would be helpful.

      Especially since I can't see how you could have two columns with the same name in Power BI.

      Later edit: Try to create two separate measures, 1 for Real% January and one for Real% February. Maybe it will work.