Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
99 | |
38 | |
37 |
User | Count |
---|---|
156 | |
121 | |
73 | |
73 | |
63 |