Forum Discussion

Responsive Resident

4 years ago

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...

Responsive Resident

4 years ago

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()

)

truptis
Community Champion
4 years ago
Could you please tell the formula for seasonality? only then we can write the DAX
- romovaro
  Responsive Resident
  4 years ago
  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()
  )
  - Anonymous
    Not applicable
    4 years ago
    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