Forum Discussion

CaveOfWonders's avatar
CaveOfWonders
Icon for Helper IV rankHelper IV
6 years ago
Solved

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:

 

 

2 Replies

  • CaveOfWonders , I doubt it used correctly. It should ask aggregation for the measure. Have taken correct measure

     

    • CaveOfWonders's avatar
      CaveOfWonders
      Icon for Helper IV rankHelper IV

      Should I be using the Measure as the Count? I am currently using the Categorical field?