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...
HI
That's the thing. I don't know how to add that part.
The formula should say, if ROle "IPM" then
July = 3 CUID
Aug = 2 CUID
Sep = 2 CUID
Oct = 3 CUID
Nov = 4 CUID
Dec = 2 CUID
Jan = 5 CUID
Feb = 3 CUID
Mar = 4 CUID
Apr = 4 CUID
May = 4 CUID
Jun = 4 CUID
And if the ROle "IC/IPM" then
July = 1 CUID
Aug = 1 CUID
Sep = 1 CUID
Oct = 1 CUID
Nov = 1 CUID
Dec = 1 CUID
Jan = 3 CUID
Feb = 3 CUID
Mar = 3 CUID
Apr = 3 CUID
May = 2 CUID
Jun = 3 CUID
Full Capacity =
Switch( true() ,
Sheet1[Role] = "IPM", 3,
Sheet1[Role] = "IC/IPM", 4,
blank()
)
Hi romovaro ,
In order to give you a suitable solution quickly, could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
HI
Let me know if that helps.
Cap-dashboard-Test.pbix (dropbox.com)
The table shows x manager who is in charge of the CUID (customer) x month.
I want to add a conditional formating using the role and how many CUID need to handle per month. (seasonability)
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 CUID