Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want Grey backgroung color where the matrix values are blank.
For that I wrote following measure but I am not getting desired output.
Can someone help!!
Solved! Go to Solution.
@Anonymous Actually matrix visual not consider blank value for conditional formating when we use Format by as field value . So we need to do one work around.
1. Update your Actual date column code with below code:-
Actual Hours =
VAR result =
IF ( WEEKDAY ( 'Employee Data'[Date], 2 ) <= 5, 'Employee Data'[Hours Worked] )
RETURN
IF ( result = BLANK (), 0, result )
2. Update your conditional formatting code with below code:-
Conditional Formatting =
IF(
SELECTEDVALUE('Employee Data'[Date])=TODAY(),
"#E7F508",
IF(
SELECTEDVALUE('Employee Data'[Actual Hours])<4.5 && SELECTEDVALUE('Employee Data'[Actual Hours])>=4,
"#08BCF5",
IF(
SELECTEDVALUE('Employee Data'[Actual Hours]) = 0,
"#859CA4"
)
)
)
You will see below output:-
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @Anonymous ,
Can you try below code:-
format =
IF (
MAX ( 'Employee Data'[Date] ) = TODAY (),
"Yellow",
IF (
MAX ( 'Employee Data'[Actual Hours] ) < 4.5
&& MAX ( 'Employee Data'[Actual Hours] ) >= 4,
"LightBlue",
IF ( MAX ( 'Employee Data'[Actual Hours] ) = BLANK (), "Grey" )
)
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
can you try below code:-
format =
VAR selected_date =
MAX ( 'Employee Data'[Date] )
RETURN
IF (
ISBLANK ( selected_date ),
"Grey",
IF (
selected_date = TODAY (),
"Yellow",
IF ( selected_date < 4.5 && selected_date >= 4, "LightBlue" )
)
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
This one is also not working!!
Is it possible for you to share PBIX file after removing confidential data?
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
@Anonymous Actually matrix visual not consider blank value for conditional formating when we use Format by as field value . So we need to do one work around.
1. Update your Actual date column code with below code:-
Actual Hours =
VAR result =
IF ( WEEKDAY ( 'Employee Data'[Date], 2 ) <= 5, 'Employee Data'[Hours Worked] )
RETURN
IF ( result = BLANK (), 0, result )
2. Update your conditional formatting code with below code:-
Conditional Formatting =
IF(
SELECTEDVALUE('Employee Data'[Date])=TODAY(),
"#E7F508",
IF(
SELECTEDVALUE('Employee Data'[Actual Hours])<4.5 && SELECTEDVALUE('Employee Data'[Actual Hours])>=4,
"#08BCF5",
IF(
SELECTEDVALUE('Employee Data'[Actual Hours]) = 0,
"#859CA4"
)
)
)
You will see below output:-
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |