Thank you so much. I was exactly looking for this video. I was working on a project where I had to conditionally format a specific column in the text table in Tableau. Earlier, I was unable to do so as color was getting applied to all the columns. This video was very helpful and now I am able to do it.
Actually, am in India and bit tied up with so many close to me getting affected by COVID. I wish you the best of health. Will soon be back in about 10-15 days with daily dose of videos 😀
And suppose I have conditional formatting on color like less than 0 is red ,more than 2 is green and between 0 to 2 is yellow , than how can this be achieved in this approach?
Standard Table for this won't work. You would need a Dual Axis table. One axis has the logic based Calculated value of Case when condition to give 0, 1 or 2. Based on this the color is done. Other axis is to show the labels. Each pair of Dual Axis will act as a column. Takes some time and effort into this one. Will make a video on this. Thanks for asking
Thank you for this video! It honestly irritates me that doing this in Tableau is so difficult. The reality is that most of the professional world is more comfortable with Excel, so it would be nice if Tableau had some simple functionalities to mimic Excel, while still having the benefits of Tableau such as reporting automation. In this case I was trying to show the percent delta b/w two figures, anything less than 0 is red, anything greater than 0 is green. Sounds so simple, but took A LOT of playing around with the color card to finally get it.
Thanks for sharing the informative video, but i have a question, how can we do the conditional formatting on seperate measure based on own condition instead of automatic color coding. For ex: i have to compare values is x>y then ‘red’ elseif x
That is a bit tricky to achieve. However, I have done that. Had to Color code green yellow or red based on tolerance value else white cell Color only of one column. Give me 3 days, will create and share with you. Need to sanitize client data and replicate for RUclips ~ Gurpreet
Thank you so much for sharing your knowledge with us. Looking forward to more Tableau tutorials.
Have resumed uploads. Thanks for the love. It helped me get back up to my schedule. ruclips.net/video/faxqH0x2hY4/видео.html
Awesome Video.... 03:44 the real magic happened!!
:)
I was working on this for hours but couldnt figure out or find on net- thank you for sharing and easy to follow details- Yes subscribed !
Wonderful!
Thank you so much.
I was exactly looking for this video.
I was working on a project where I had to conditionally format a specific column in the text table in Tableau. Earlier, I was unable to do so as color was getting applied to all the columns. This video was very helpful and now I am able to do it.
You're very welcome!
Thank you for this video. This is exactly what I was looked for.
Glad it was helpful!
clear and to the point explanation, thanks
This is so good and please do more videos on tableau I already subscribed for chanel 👍
Actually, am in India and bit tied up with so many close to me getting affected by COVID. I wish you the best of health. Will soon be back in about 10-15 days with daily dose of videos 😀
@@dashdevpro oh okay no issues, take your time, and whenever you feel comfortable, then you can make videos.. thanks for the reply. 👍
@@RameshCh-me8jm Have resumed uploads. Thanks for the love. It helped me get back up to my schedule. ruclips.net/video/faxqH0x2hY4/видео.html
Thank you and subscribed
Thanks for the sub!
Great video sir. Crisply explained
Thank you Varun. Keep watching
great video, thanks for that
AMAZING solution and video
Really helped, thanks a lot!
What is conditional formatting..?
And suppose I have conditional formatting on color like less than 0 is red ,more than 2 is green and between 0 to 2 is yellow , than how can this be achieved in this approach?
Standard Table for this won't work. You would need a Dual Axis table. One axis has the logic based Calculated value of Case when condition to give 0, 1 or 2. Based on this the color is done. Other axis is to show the labels. Each pair of Dual Axis will act as a column. Takes some time and effort into this one. Will make a video on this. Thanks for asking
@@dashdevpro Hi Dev, I am exactly looking for this. Wondering if you have created video on this?
@@priyankawadhwa8335 making and uploading in 3 more days.
Have added that video. Hope it helps ruclips.net/video/faxqH0x2hY4/видео.html
Great work! Thanks
thank you, great help
🙏🏼 Thanks. It's been a while. Will surely up my game and resume my videos. Thanks for the subscribe
How to do it on rows?
How to avoid color in null or blank cells?
thank you, very helpful!
Fantastic video. Thankyou.
Glad you enjoyed it!
Thank you for this video! It honestly irritates me that doing this in Tableau is so difficult. The reality is that most of the professional world is more comfortable with Excel, so it would be nice if Tableau had some simple functionalities to mimic Excel, while still having the benefits of Tableau such as reporting automation.
In this case I was trying to show the percent delta b/w two figures, anything less than 0 is red, anything greater than 0 is green. Sounds so simple, but took A LOT of playing around with the color card to finally get it.
Thanks for sharing the informative video, but i have a question, how can we do the conditional formatting on seperate measure based on own condition instead of automatic color coding. For ex: i have to compare values is x>y then ‘red’ elseif x
That is a bit tricky to achieve. However, I have done that. Had to Color code green yellow or red based on tolerance value else white cell Color only of one column. Give me 3 days, will create and share with you. Need to sanitize client data and replicate for RUclips ~ Gurpreet
Have added that video. Hope it helps ruclips.net/video/faxqH0x2hY4/видео.html
My text disappears when I conditionally format columns by color sqaure shaped
Have you changed your text color from Default?
Thankyou sir
Thank you