Forum Discussion
Conditional Formatting Colour Scale Not Shading Correctly
Hi All,
I created the Stacked Bar Chart below based on one categorical Field with 4 distinct values and dropped a measure into the Value box and attempted to apply conditional formatting based on the count. As you can see there seems to be something wrong here as the top bar (A) is a lighter shade of purple than the bar below it (B). Why is this not shading correctly?
The calculation of the measure being used:
Field =
CALCULATE (
COUNTROWS (
FILTER (
'Table 1',
'Table 1'[Completion Date] <> BLANK ()
&& 'Table 1'[Completion Date] < 'Table 1'[Planned Completion Date])))
Chart
Conditional Formatting:
Measure:
CaveOfWonders , I doubt it used correctly. It should ask aggregation for the measure. Have taken correct measure
2 Replies
- amitchandak
Super User
CaveOfWonders , I doubt it used correctly. It should ask aggregation for the measure. Have taken correct measure
- CaveOfWonders
Helper IV
Should I be using the Measure as the Count? I am currently using the Categorical field?