Forum Discussion
Adding filter (Conditional formatting) to table
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.
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())
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