Forum Discussion

elliegri's avatar
elliegri
Regular Visitor
2 years ago
Solved

Colour Conditional Formating

Hi all, I am new to Power BI and I am trying to create a graph that drills down from month to days to PCN to Practice - (I am working in healthcare). I have done this however I need to match the Pr...
  • vicky_'s avatar
    vicky_
    2 years ago

    elliegri 

    this is what i meant by formatting the values based on heirarchy with HASONEVALUE() - except, just replace Orange with the rules you need for when there's more than 1 practice.

     

vicky_'s avatar
vicky_
Super User
2 years ago

As you've noticed, the issue arises when there's more than 1 practice - and this is because the SELECTEDVALUE() function returns a blank in that case, so the lookup fails. One way around this is by wrapping your lookup in HASONEVALUE() - i.e:

Data Colour Admin = IF(HASONEVALUE(Table[Practice]), 
    // simply look up the colour..., 
    // else, your fallback logic here
)