Forum Discussion

KBUIUS's avatar
KBUIUS
Icon for Helper I rankHelper I
4 years ago
Solved

Conditional Formatting: wrong individual format

I am using conditional formating in a table. For some reason that single cell just turns dark blue because it thinks it's a maximum value in that range. Any thought why this could happen ?      ...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    KBUIUS that is the issue, conditional formatting is using sum of net loss but in visual you are showing non summarize data, and that is the problem. You are working with two different numbers.

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

KBUIUS is that column in the table showing  sum of net loss?

 

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    This is my thought as well.

     

    KBUIUS In other words, are you formatting the column using the same measure as you're showing in that column?

    • KBUIUS's avatar
      KBUIUS
      Icon for Helper I rankHelper I
      4 years ago

      That's the column Net Loss

    • KBUIUS's avatar
      KBUIUS
      Icon for Helper I rankHelper I
      4 years ago

      In the values, I chose "dont' summarize" for Net Loss. Idk if that causes inconsistency... 

       

      • AlexisOlson's avatar
        AlexisOlson
        Icon for Super User rankSuper User
        4 years ago

        What happens if you switch to Sum like the conditional formatting is using?