Conditional formatting in table with measure and dates

[javierdhv]

Hi my name is Javier. It's my first post here but I have been checking the web every now and then for that, I really appreciate the work of the community.

This time my problem is with the conditional formatting in table with a measure. I would like to include an icon with a green, yellow and red arrow in case the week before is more, equal or less than the current week.

I have tried to do it as always, but I think the accumulate measure is making me a trouble. I have attached a link with a small replica of my data to check it. https://drive.google.com/open?id=1Octv7ogBSxFxQNcN8mZ3-AN9x7hDKwxR.

Thanks for all your answers in advanced.

[v-deddai1-msft · Accepted solution]

Hi, 

Would you please follow the steps below?

Create a meausre to return a specific value of 0,1,2 to be used later to display the style and color of the icon:

Measure = IF([ad - # of ads week ago] > [AD - # of ads WoW],2,IF([ad - # of ads week ago] = [AD - # of ads WoW],0,1))

Add the measure to the table visualization and set the icon to display for it:

Set rules for it as you want:

For more details, please refer to https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EV-aF_BUAhJKrEecPa...

Best Regards,

Dedmon Dai

[javierdhv]

 Thanks. 😉

[Stachu]

the easiest way is to create a new measure like this:

Arrows = SIGN([AD - # of ads WoW]-[ad - # of ads week ago])

it returns -1,0 or 1 depending on whether the difference is negative, 0 or positive

then use it to set the conditional formattiing on  [AD - # of ads WoW]

it should now display as you expect