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 , Create a new color measure
Switch( True() ,
[target quantity] = 3 && [OnHand Qunatity] >=3 , "Green",
[target quantity] = 3 && [OnHand Qunatity] < 3 , "Red",
[target quantity] = 13 && [OnHand Qunatity] >=13 , "Green",
[target quantity] = 13 && [OnHand Qunatity] <13 , "Red"
)
Change the value as per need. Use in conditional formatting using field value option
How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4
Hi amitchandak , Thank you!
Sorry, i'm still new to this but why it says 'cannot find name'?
do i need to declare something first?