Forum Discussion

javierdhv's avatar
javierdhv
Frequent Visitor
6 years ago
Solved

Conditional formatting in table with measure and dates

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.

Need Help

3 Replies

  • Stachu's avatar
    Stachu
    Community Champion
    6 years ago

    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

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    6 years ago

    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_BUAhJKrEecPa5FX-sBG3YKqWVkGT-37HbmXlDT9w?e=eFRIUr

     

    Best Regards,

    Dedmon Dai