Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
---|---|
84 | |
76 | |
74 | |
48 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |