4 Replies Latest reply on Sep 28, 2018 12:32 AM by Naveen B

    Simple conditional formatting implementation in tableau

    Rohan Bapat

      I need to implement an easy MS Excel style conditional formatting in Tableau. I have a csv file as below -

       

       

      I want to convert this to a conditional formatted table like below. All I want to do is to replace the text with colored circles. Red circle indicating True and Green circle indicating False. The circles will also have a hover tooltip that I can design once I create this visualization.

       

       

                                                                                            

      Feature AFeature BFeature C
      User 1TRUETRUETRUE
      User 2TRUEFALSETRUE
      User 3TRUETRUEFALSE
      User 4FALSEFALSEFALSE
      User 5TRUEFALSEFALSE
      User 6TRUEFALSETRUE
      User 7FALSEFALSEFALSE
      User 8FALSEFALSETRUE
      User 9TRUEFALSEFALSE
      User 10TRUEFALSEFALSE

      Disclaimer - Now I understand that this is not the use case for which Tableau has been built. But unfortunately, this visualization is a part of a huge Tableau dashboard with lots of other visualizations as well. Hence I need to use Tableau for this purpose.

       

      I have tried multiple approaches such as dragging the dimensions into rows and columns, but it creates a huge mess. Please let me know if this can be accomplished using tableau.