You can make a calculated field comparing the measure in the bar (let's say SUM([Sales]) to the constant.
SUM([Sales]) > [PA_Constant]
IF [CF_SalesHigher] THEN "▲"
Then you can do comparison against Constant to make two different fields - one good, one bad.
Finally drag each onto your text/label pane, color appropriately, and align Top Center.
Hope this helps! Attached 10.3 twbx for reference.
Variance Triangle_10.3.twbx 1.1 MB
Thanks a lot sankar. its really helpful.
My requirement is a comparison between two bars of last year current month to this year current months profit & this for 3 types of Products.
If this year current month is higher than last year current month , then GREEN SMALL UP ARROW &
if this year current month is less than last year current month , then RED SMALL DOWN ARROW without affecting the Bar colors.
If both have same value , then no arrow.
Ex:- Comparision between June 2017 & June 2018.
Small arrows to be above June 2018 & should dynamically change with the changed filter option.
how to do that?
I could nt find the attached file,
Can you Please attach it again.?
Hi thanks a lot for your response.
It is helpful for me.
Please share the steps to achieve the above what you have posted.
Thanks again for your reply.
I am able to put arrows,
How to put Red & Green arrows without changing the neighboring value or Bar.
Hmm. Not entirely sure what you mean. Can you post screenshot or your entire sheet?