Help with conditional formatting

[DRJ1994]

Hi all,

I am trying to set up conditional formatting on a table of mine, please see screenshot below:

The table shows a target date, and a column which shows the amount of days between today and the target date.

I am trying to get the conditional formatting to behave as follows:

less than 100 days = red

101-365 = blue

366 +  = green

As you can see from the screenshot I have the rules set up to reflect this, but when I click ok on the formatting box, nothing is changing (the majority should change to blue, and one should change to green, but instead everything is just staying as is)

Any tips or help would be greatly appreciated.

Thanks,

DRJ

[Pady]

Hope this helps:

[JadhavVarsha_13]

hello @DRJ1994 

It should work, you have followed the correct steps i recogn, you can still recheck the steps here - https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

[DRJ1994 · Accepted solution]

Thanks - I have resolved it now by changing the summarization to Maximum, rather than sum.