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

v-lili6-msft's avatar
v-lili6-msft
Community Support
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