Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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
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
Thanks. 😉
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
User | Count |
---|---|
141 | |
70 | |
70 | |
54 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |