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 conditi...
Need Help
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

  • javierdhv's avatar
    javierdhv
    Frequent Visitor
    6 years ago

     Thanks. ğŸ˜‰