Conditional formatting two measures in a stacked bar chart

Question

Hi All&nbsp;I have a stacked bar chart with two measures used in the values section (Planned Admission Count and Predicted Admission Count)&nbsp;I want to apply a RAG status here haven't found a solution yet.&nbsp;e.g. if planned admission count &lt; 5 then greenand if predicted admission count &lt; 5 then a lighter shade of green.&nbsp;I tried creating two SWITCH() measures on top of these measures but it only works for if you have a single measure in the bar chart as you value.&nbsp;e.g.&nbsp;Predicted Admissions RAG = SWITCH(TRUE(), [Predicted Admission Count] &lt; 5, "#31A175", [Predicted Admission Count] = 5, "#FFAB05", [Predicted Admission Count] &gt; 5, "#EE4837")&nbsp;Below is what I see if I only place the Predicted Admissions Count on the stacked bar chart&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I have found people asking similar questions here but I don't really want overlay two visuals.Any advice would be appreciated.&nbsp;Thanks

v-lili6-msft · Accepted Answer

HI&nbsp;&nbsp;D1ltang&nbsp;
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&lt; 5 = IF([Predicted Admissions Count]&lt;5,[Predicted Admissions Count])Predicted Admissions Count&gt;5 = IF([Predicted Admissions Count]&gt;=5,[Predicted Admissions Count])
&nbsp;
Then set datacolour as below:

&nbsp;
&nbsp;
Regards,
Lin

Forum Discussion

Conditional formatting two measures in a stacked bar chart

2 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting