Forum Discussion

marvicf's avatar
marvicf
Frequent Visitor
4 years ago

Conditional formatting

Hi, I set up a measure to apply conditional formatting to a table visual according to the measure's value   ZoneSelectedWeek = if(ISBLANK(SELECTEDVALUE(Weekly_Extract[WeekNo])),1,2)   The measu...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

marvicf , Try a measure like

 

ZoneSelectedWeek = if(calculate(isfiltered(Weekly_Extract[WeekNo]), allselected() ),2,1)

marvicf's avatar
marvicf
Frequent Visitor
4 years ago

Hi and thanks for your reply

 

Tried the measure you suggested but still no luck. The measure is working fine as I assigned it to a card visual to see its value and when I select the week it's value changes. The issue is that in the table visual the column background is always the color for value 2 and won't change after that

Thanks