Forum Discussion

Akshay_echo1995's avatar
Akshay_echo1995
Regular Visitor
2 years ago

Conditional Formatting not executting completely.

Hi Everyone,   We have 2 columns one with user name and on other we have the login date when they have last logged in, when we are trying to do conditional formatting to check whether they are logi...
Need Help
PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi Akshay_echo1995 

Please try below DAX

 

DRV2 =
IF (
   ( SELECTEDVALUE ( 'DW Celoxis_TimeEntries'[data']][0]]['workItem_data_plannedStart] ) - Today()) <= 7,
    "Green",
    IF (
       ( SELECTEDVALUE ( 'DW Celoxis_TimeEntries'[data']][0]]['workItem_data_plannedStart] ) - Today())<= 14,
        "Amber",
        "Red"
    )
)

 

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

  • Akshay_echo1995's avatar
    Akshay_echo1995
    Regular Visitor
    2 years ago

    Aleady tried this but only getting Green , its not getting executed for Amber and Red.

    • PijushRoy's avatar
      PijushRoy
      Community Champion
      2 years ago

      Hi Akshay_echo1995 

      Hope this column in Date format 

      'DW Celoxis_TimeEntries'[data']][0]]['workItem_data_plannedStart]

      You are calculating measure and using the measure in Field value of the conditional formatting

      Please create a sample PBIX and share the google drive link


       


      Let me know if that works for you


      If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

      Thanks
      Pijush
      Linkedin