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

  • @draganhub
    @draganhub3 жыл бұрын

    Thank you so much for sharing your knowledge with us. Looking forward to more Tableau tutorials.

  • @dashdevpro

    @dashdevpro

    Жыл бұрын

    Have resumed uploads. Thanks for the love. It helped me get back up to my schedule. kzread.info/dash/bejne/mJWs06ppqJXOiZc.html

  • @NikitaSharma-bs4gg
    @NikitaSharma-bs4gg2 жыл бұрын

    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

    @dashdevpro

    Жыл бұрын

    Wonderful!

  • @sambitguru8374
    @sambitguru8374 Жыл бұрын

    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

    @dashdevpro

    Жыл бұрын

    You're very welcome!

  • @sorosfox3801
    @sorosfox38012 ай бұрын

    Great work! Thanks

  • @marcinurbanski4877
    @marcinurbanski48772 жыл бұрын

    Thank you for this video. This is exactly what I was looked for.

  • @dashdevpro

    @dashdevpro

    Жыл бұрын

    Glad it was helpful!

  • @nahor88
    @nahor88 Жыл бұрын

    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.

  • @user-dt1mb1rs4b
    @user-dt1mb1rs4b5 ай бұрын

    clear and to the point explanation, thanks

  • @amansagar5946
    @amansagar59462 жыл бұрын

    Awesome Video.... 03:44 the real magic happened!!

  • @dashdevpro

    @dashdevpro

    Жыл бұрын

    :)

  • @hoosier-daddy465
    @hoosier-daddy4655 ай бұрын

    AMAZING solution and video

  • @RameshCh-me8jm
    @RameshCh-me8jm3 жыл бұрын

    This is so good and please do more videos on tableau I already subscribed for chanel 👍

  • @dashdevpro

    @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

    @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

    @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

  • @user-kz1le2ys1g
    @user-kz1le2ys1g Жыл бұрын

    Really helped, thanks a lot!

  • @rohinattrey8022
    @rohinattrey8022 Жыл бұрын

    thank you, very helpful!

  • @josecampollo3741
    @josecampollo3741 Жыл бұрын

    great video, thanks for that

  • @darkk3nt807
    @darkk3nt8072 жыл бұрын

    Thank you and subscribed

  • @dashdevpro

    @dashdevpro

    Жыл бұрын

    Thanks for the sub!

  • @frankcincotta699
    @frankcincotta6992 жыл бұрын

    Fantastic video. Thankyou.

  • @dashdevpro

    @dashdevpro

    Жыл бұрын

    Glad you enjoyed it!

  • @Inos74
    @Inos742 жыл бұрын

    thank you, great help

  • @dashdevpro

    @dashdevpro

    2 жыл бұрын

    🙏🏼 Thanks. It's been a while. Will surely up my game and resume my videos. Thanks for the subscribe

  • @Suhaibiq
    @Suhaibiq2 жыл бұрын

    Great video sir. Crisply explained

  • @dashdevpro

    @dashdevpro

    Жыл бұрын

    Thank you Varun. Keep watching

  • @LetsMazze
    @LetsMazze10 ай бұрын

    Thank you

  • @priyankawadhwa8335
    @priyankawadhwa8335 Жыл бұрын

    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

    @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

    @dashdevpro

    Жыл бұрын

    Have added that video. Hope it helps kzread.info/dash/bejne/mJWs06ppqJXOiZc.html

  • @hanisharora8341
    @hanisharora8341 Жыл бұрын

    How to do it on rows?

  • @kundanpatil9783
    @kundanpatil97832 жыл бұрын

    How to avoid color in null or blank cells?

  • @sriharin7666
    @sriharin7666 Жыл бұрын

    What is conditional formatting..?

  • @monaleenrath6405
    @monaleenrath64052 жыл бұрын

    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

    @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

    @priyankawadhwa8335

    Жыл бұрын

    @@dashdevpro Hi Dev, I am exactly looking for this. Wondering if you have created video on this?

  • @dashdevpro

    @dashdevpro

    Жыл бұрын

    @@priyankawadhwa8335 making and uploading in 3 more days.

  • @dashdevpro

    @dashdevpro

    Жыл бұрын

    Have added that video. Hope it helps kzread.info/dash/bejne/mJWs06ppqJXOiZc.html

  • @786gohan
    @786gohan2 жыл бұрын

    My text disappears when I conditionally format columns by color sqaure shaped

  • @dashdevpro

    @dashdevpro

    Жыл бұрын

    Have you changed your text color from Default?

Келесі