Background color help on Table

[pawwy1415]

Hi Experts,

Can any one please help me on below issue.

I have Created a Table like below

Taken Row as Status ,

Column as Date

Measure as =Count({<[Month Name]=, Year=>}distinct ID)

Here for the Status=For Attn total row I need to apply the orange color.

So in the Background color expression I have applied like 

if(Status='For Attn',RGB(255,153,51)) but its applied to only for 16 not for 5,9,8 ,

because in this app applied [Month Name]= Nov as default selection so orange color was applied on only 13/11/2018.please help me to apply for complete row of all the Months dates.

Thanks in advance.

[agni_gold]

Can you share your dashboard?

[pawwy1415]

Hi
Sorry I Cant share the app . I have added the expression and screen shots.

[timpoismans]

Based on what you've told us, there's no reason why it shouldn't apply to the whole row.

What exactly do you mean with "because in this app applied [Month Name]= Nov as default selection"

Selections shouldn't influence the background color you've set based on a row dimension.

[pawwy1415]

Hi
Thanks for your reply.
Your understanding is correct. Could you please suggest any way to resovle this issue.

[timpoismans]

Without having a sample app with the issue already in it, I can't suggest anything as I have no way to see what's actually going wrong. 

I haven't had any success reproducing the issue, so I can't help you solve it, sadly.

[pawwy1415 · Accepted solution]

I have found a way actually default selection extension causing the issue I have deleted the extension and applied the Max(Month) inside set analysis