Forum Discussion
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...
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
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