How to add dynamic up and down KPI arrows in Tableau - 2 ways | Tableau Quick Tip | sqlbelle 

Thank you. This was extremely useful!

Brilliant use of font colour , I thought we were going to create a separate calc field for color and drop it to color field

This was asked in my last Interview. Thanks for the solution

THIS IS GOLD. Thanks so much! Really helpful

thank you, very simple and effective

Thank you for the great tip, I tried the same but due to some reason I couldn't get the triangle shapes, so used ascii ALT+30 and ALT+31 to get triangle shapes.

Anybody ever tell you you have such a "soothing" teaching voice that allows the student to relax, and take in things and process information much easier?

This is awesome. Thanks!

Extremely useful.

Amazing. Thanks a lot.

Hello, When I try to copy the arrow marks from Word I get check marks in Tableau?

Hi! THE ARROWS...HOW DO I GET THEM? I cannot seem to copy into Tableau the Word or PNG arrows that I have on file and the ALT+30 0r 31 is not working- Please help

hi , great technique is there a way to create the up and down arrows only for a specific measure , if i have multiple measures in tabular chart ?

What if I have to add one more Measure to the table? It is showing the arrow for both the % difference and the actual measure. I want it only for the % difference

Great video, but sad that Tableau has not integrated an easy and convenient way to do this.

how about arrow up and down comparing months like for example Feb is 10 then March is 15 so arrow up then April is 12 so arrow down

I don’t know why. But this worked the 1st time. Now it won’t Color anything anymore 🤔

What about 0% change values. Using your method, for 0% values sometime up or sometime down arrow is appearing. Can you show how to add a different symbol for 0%

Thank You. It is extremely useful. Added Bonus for me was dragging the measure from the Mark and making it a calculated field. Amazing

What about 0%change. With your method, 0% values are showing as up arrow for some rows and vice versa. Can you show how to add a different symbol for 0%change.

Hi.. I a using tableau public and not able to get the arrows instead i am getting different numbers while pasting the arrow from MS word to tableau.Can you help

Wow... Can't believe it can be done in such a simple way. 👍 Wondering if I can use negative arrow in "else" clause 🤔 not sure if I am missing something if this not work 😀

If you wanted to compare values a time series to the prior value in the which of the following would allow you to accomplish this easiest in Tableau

This works if you don’t need totals. What if i want to insert up and down arrows with colors and totals for only specific measures?

How I can get the shapes only for specific measure, by using this method its place icons on all measure, please let me know.. thanks in advance

If we get fixed color for the negative and positive values from client then we can take those shapes of those color from text editor here ms word directly and can put in measure format under pane window in last custom option

Could you tell how you copied the arrows from word to custom format? I am trying and its not working. Thank you Belle

Thankyou ,very beneficial but I want to ask what actually KPI's are ??

Very nice video thanks! What if I have multiple measures? I tried to create a calculated field for each measure but it does not work :/ Thanks :)

The tooltip color is not changing for up and down arrows for 2017, its showing same how to achieve that?

great explanation, but damn, tableau is stupid -- this should be so easy, yet they make it so convoluted

One word Amazing... You saved my day. God Bless YOU & ur family, friends, neighbors etc..

Can you please make video for conditional colour formatting .. like we have different table for threshold value and as per that another table data color will change

Great Nicely Explained,Enjoyed the Video. Thanks

@sqlbelle, How can I limit the indicator to just one column like a column that indicates the total or sum of other columns?

HI , Excellent Explanation. Please upload more videos on Tableau. Thank you

Thanks for this it's great. Do you have a video for creating the same visual but showing the difference between today and yesterday

I’ve Made so many charts I’m running out of ways to show data. This was nice. Thanks

Awesome 🤩Exceptional skills or should i call it Expertise 🤔

i have many columns and i want to use only 2 and this doesn't work at all on my problem

Nice content, but how to doif we have multiple measures ?

How can I only show the colored arrows in one column and not all of them? Thanks

You are Magician!!! Thank you SqlBelle. Happy Holidays.

Thank you, i like the most things in your video are used for business dashboard really thank you again

How would I show the up/down once at the end of the list which should represent increase/decrease when comparing Current Year Volume to Previous Year Volume (at all times). So even if they expand the date view, it still is based on Current Year vs Previous. My head I am thinking this would be added as a shape, separately as a calculated field... and then calculated fields for current and previous year total.

Thank you so much. Appreciated your effort. You have provided me with great learning resources.

Very useful, to the point solution. Loved it.

Awesome video and tips!!!! I need some assistance. I’m following all of the suggestions you mention in terms of coloring the arrows but when I implement it there is no coloring. In the preview window, I get my value then the black up arrow followed by 2 NULLS displayed with the appropriate coloring. Not sure what I’m doing wrong.

Thank you so much, Very detailed and informative video.

Thank you! This is very helpful 👍🙏

Hi I need help .. how can we show these arrows with colors for different measures on same worksheet like u have only profit measure but I have different measures like MOM% for : profit ,sales , balances and many more.. pls help

pls do same kind of session for Animations in tableau

You are teaching difficult things in easy way, thanks

awasome . Extremly simple and very useful

Very nice!! There's a way to add colour with the first way? I have many columns and with the second way only work with one colum

Thank you for sharing this! very simple and effective!!!

Niiiiiceee!!! Just the thing I needed :) Thank you!

thank you for your tutorial!, How can show indicators without showing the previous months?

Can this be used for just increase or decrease by number and not percentage?

Hello sqlbelle, thanks for the excellent tutorial! I have adapted this method in a particular way, but need help with color. My table shows the median days it took to process a particular kind of document each month, plus arrows or equal signs indicating whether that value is more, less, or equal to the previous month's value (so I've created three calculated fields--one for each arrow, and one for the equal sign, and they are using the same Quick Table Difference calculation which determines whether the current month is more, less, or equal to the previous month). The challenge I'm facing is: I need the arrow or equal sign (which is generated by the running difference calculation) to be either red or green based on whether the monthly median processing days value is below/equal to OR above a certain threshold--the symbol (which is tied to the difference calculation) needs to be green if the monthly median value is below or equal to the threshold, and red if above. So the median value would control the color of the running difference symbol. If you're interested in this problem, is there a way I can get in touch with you?

Thanks for such amazing video.

When I try this I am getting 2 arrows mam

Thanks you.. Extremely useful..

AMAZING!!!!!

My image isn't pasting in formula. Please help

this is awesome, lovely tip. thank you soo much

Wonderful! Thank you!

So underrated

you dont know how much i really need this, thank you sooooo much

Very Simple and extremely useful.

Thanks a lot. Very useful !!

Super cool! Thanks!

Thx Bella. Well it really helps 👍

Thank You ! But the lower triangle is not working dynamically for my KPI, I am using 2020.4.2 in first method

Hi How can we show the same in Month on moth growth or decline of profit

Great video!

Hi, Thank you for the video. That was very helpful. Can you please explain what to do if you only want to show the result for the most recent year or month and its trend indicator (arrow) without showing the other columns (or years / months)? Is it possible?

hi. is it possible to have checkbox icon in just one column in a spreadsheet view? basically it a normal table but one column is a conditional true or false in a form of a check/uncheck box icon

Iam not able to paste that arrow 😢😢😢😢

Hi Really great..Can you please share the dataset for the viz.

Thank you 🦋

2015 year values are not visible...

Merci Miss.

Fantastic

This is perfect!

.........Bravo! 👍

Thank you!!