Forum Discussion

D1ltang's avatar
D1ltang
Frequent Visitor
6 years ago
Solved

Conditional formatting two measures in a stacked bar chart

Hi All   I have a stacked bar chart with two measures used in the values section (Planned Admission Count and Predicted Admission Count)   I want to apply a RAG status here haven't found a ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    HI  D1ltang 

    Since there are two measure in stacked bar chart, so it could not achieve use conditional formatting.

    As a workround, you could divide [Predicted Admissions Count] into two measure as below:

    Predicted Admissions Count< 5 = IF([Predicted Admissions Count]<5,[Predicted Admissions Count])
    Predicted Admissions Count>5 = IF([Predicted Admissions Count]>=5,[Predicted Admissions Count])

     

    Then set datacolour as below:

     

     

    Regards,

    Lin

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

D1ltang afaik, if you are using legend or multiple measures, it doesn't have the functionality for conditional formatting, only when a single measure is used and no columns in the legend, you can use the conditional formatting.

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡