Forum Discussion
Power BI colour formating
RYG = IF (ISBLANK ( VALUES ('Dashboard'[Define]) ),"#FFFFFF",IF (VALUES ('Sort'[Plan/Actual]) = "Plan" && VALUES ('Dashboard'[Define]) < TODAY (),"#BEBEBE",IF (VALUES('Sort'[Plan/Actual]) = "Actual" && VALUES ('Dashboard'[Define]) < TODAY (),"#92D050","#FFFFFF")))
this Dax I wrote for Define colour formating. My Define column have plan and actual date, if plan and actual date past due at the same time plan date and actual date are same date, plan date will become grey colour; actual date will become green colour. Example, plan date is 31-Jan-2024 and actual date is 31-Jan-2024. I need help to 1 condition, if actual date different with plan date, plan date will remain grey colour, actual date become yellow colour. Example plan date is 31-Jan-2024, actual date is 24-Jan-2024.
Can advise me the DAX?
Hi joce1127
Change the "values" function which returns the table to selectedvalue().
More information about the function :https://learn.microsoft.com/en-us/dax/selectedvalue-function
+
you can take a look at my solution in the linked discussion with pbix with a similar scenario.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
- Ritaf1983
Super User
Hi joce1127
Change the "values" function which returns the table to selectedvalue().
More information about the function :https://learn.microsoft.com/en-us/dax/selectedvalue-function
+
you can take a look at my solution in the linked discussion with pbix with a similar scenario.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly