Conditionally Format each Column in Tableau Crosstab Table
Ғылым және технология
Ever wanted to format each column separately in a Tabular/Crosstab data visualization in Tableau. Here's a Quick-Tip for you.
Do leave a like and subscribe for more videos every Monday, Wednesday and Friday like these where I try to share my know-how and learning experience of data & dashboards.
Пікірлер: 43
Thank you so much for sharing your knowledge with us. Looking forward to more Tableau tutorials.
@dashdevpro
Жыл бұрын
Have resumed uploads. Thanks for the love. It helped me get back up to my schedule. kzread.info/dash/bejne/mJWs06ppqJXOiZc.html
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 !
@dashdevpro
Жыл бұрын
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.
@dashdevpro
Жыл бұрын
You're very welcome!
Great work! Thanks
Thank you for this video. This is exactly what I was looked for.
@dashdevpro
Жыл бұрын
Glad it was helpful!
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.
clear and to the point explanation, thanks
Awesome Video.... 03:44 the real magic happened!!
@dashdevpro
Жыл бұрын
:)
AMAZING solution and video
This is so good and please do more videos on tableau I already subscribed for chanel 👍
@dashdevpro
3 жыл бұрын
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 😀
@RameshCh-me8jm
3 жыл бұрын
@@dashdevpro oh okay no issues, take your time, and whenever you feel comfortable, then you can make videos.. thanks for the reply. 👍
@dashdevpro
Жыл бұрын
@@RameshCh-me8jm Have resumed uploads. Thanks for the love. It helped me get back up to my schedule. kzread.info/dash/bejne/mJWs06ppqJXOiZc.html
Really helped, thanks a lot!
thank you, very helpful!
great video, thanks for that
Thank you and subscribed
@dashdevpro
Жыл бұрын
Thanks for the sub!
Fantastic video. Thankyou.
@dashdevpro
Жыл бұрын
Glad you enjoyed it!
thank you, great help
@dashdevpro
2 жыл бұрын
🙏🏼 Thanks. It's been a while. Will surely up my game and resume my videos. Thanks for the subscribe
Great video sir. Crisply explained
@dashdevpro
Жыл бұрын
Thank you Varun. Keep watching
Thank you
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
@dashdevpro
Жыл бұрын
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 KZread ~ Gurpreet
@dashdevpro
Жыл бұрын
Have added that video. Hope it helps kzread.info/dash/bejne/mJWs06ppqJXOiZc.html
How to do it on rows?
How to avoid color in null or blank cells?
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?
@dashdevpro
2 жыл бұрын
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
@priyankawadhwa8335
Жыл бұрын
@@dashdevpro Hi Dev, I am exactly looking for this. Wondering if you have created video on this?
@dashdevpro
Жыл бұрын
@@priyankawadhwa8335 making and uploading in 3 more days.
@dashdevpro
Жыл бұрын
Have added that video. Hope it helps kzread.info/dash/bejne/mJWs06ppqJXOiZc.html
My text disappears when I conditionally format columns by color sqaure shaped
@dashdevpro
Жыл бұрын
Have you changed your text color from Default?