Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
javierdhv
Frequent Visitor

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.

1 ACCEPTED SOLUTION
v-deddai1-msft
Community Support
Community Support

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:

 

Untitled picture.png

 

Set rules for it as you want:

 

Untitled picture1.png

 

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

View solution in original post

3 REPLIES 3
v-deddai1-msft
Community Support
Community Support

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:

 

Untitled picture.png

 

Set rules for it as you want:

 

Untitled picture1.png

 

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

 Thanks. 😉

Stachu
Community Champion
Community Champion

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]

Capture.PNG

it should now display as you expect



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.