Forum Discussion
Adding filter (Conditional formatting) to table
Happy Friday
I need some help adding a filter in a table. I have the table below with Manager's Name, Associates, ROle and Project Number.
The conditional formating is showing Green Orange or Red according if total projects are less than 2, between 2 and 4 or more than 4 (per month) during the whole year.
Now I want to the conditional formating to show the Seasonality below instead of less than 2, 2 to 4 and +4 for the whole year-
Is it possible to add total of projects (CUID) and select different max filter per month?
Currently the conditional formating shows:
thanks
f
6 Replies
thanks Truptis
Currently I have the formula below who can show the "Full capacity" according to Role "IPM" and "IC/IPM"
But I don't know how to add the "seasonality" in the formula.
Full Capacity =Switch( true() ,Sheet1[Role] = "IPM", 3,Sheet1[Role] = "RPM", 4,blank())Could you please tell the formula for seasonality? only then we can write the DAX
- HIThat's the thing. I don't know how to add that part.The formula should say, if ROle "IPM" thenJuly = 3 CUIDAug = 2 CUIDSep = 2 CUIDOct = 3 CUIDNov = 4 CUIDDec = 2 CUIDJan = 5 CUIDFeb = 3 CUIDMar = 4 CUIDApr = 4 CUIDMay = 4 CUIDJun = 4 CUIDAnd if the ROle "IC/IPM" thenJuly = 1 CUIDAug = 1 CUIDSep = 1 CUIDOct = 1 CUIDNov = 1 CUIDDec = 1 CUIDJan = 3 CUIDFeb = 3 CUIDMar = 3 CUIDApr = 3 CUIDMay = 2 CUIDJun = 3 CUIDFull Capacity =Switch( true() ,Sheet1[Role] = "IPM", 3,Sheet1[Role] = "IC/IPM", 4,blank())
