Forum Discussion
Solved
Conditional Formatting based on specific value for each row
Hi i need help to make conditional formatting but each row depends on different value. at 'On Hand qty', the background color depends on the 'Target quantity' such as: on the fifth row, 'ta...
muhaiza Please update your code as below:-
measure 3= IF ( SUM ( INF[On Hand Qty] ) >= INT ( MAX ( INF[Target Quantity] ) ), "Green", "Red" )Output:-
muhaiza Is it possible for you to share your PBIX file after removing sensitive data?
Hi Samarth_18 ,
this is the link. Thank you!
https://drive.google.com/file/d/1PxUzDk9NABnJJukSb1DBb0UwRXOz-2Bg/view?usp=sharing
muhaiza Please update your code as below:-
measure 3= IF ( SUM ( INF[On Hand Qty] ) >= INT ( MAX ( INF[Target Quantity] ) ), "Green", "Red" )Output:-
Samarth_18 Thank youuu so much!!