Kind of unbelievable that something so simple requires such an elaborate workaround. Thanks for sharing!

It blows my mind that it takes this much hacking to get such a simple feature. At any rate, this tutorial is hugely beneficial. Thank you!

I'm producing dashboards for Finance and tables are quite important still for visualisation for this group of stakeholders so this video is really good! Thanks for putting this up since 2014 and I think it was done by Andy Kiebrel who is a Tableau legend.

Thanks for taking the time to make this video and also linking to it in different places on the forums. I knew it was possible but totally forgot this approach. Even when I started working through the steps I really needed the hand holding even though some steps seem sort of obvious at this point. Thank you!

Kitokos miiiiiingi penza. Nzoto esali ngayi malili. Mudimu muimpa beh bana betu. Mosala kitoko mingi ba ndeko na ngayi, kazi muzuri saaana ba ndugu yangu eeee. Pardon, na yebi Kikongo te, oyo ayebi abakisa. To yeba minoko nionso ya mboka ba ndeko. Eyali na lotomo eee. Tuasakidila, aksanti, matonodo, merci.

I have been looking for something like this for a while now and im glad i stumble over this vid, i wish i could give you a thousand likes, thankyou soo much :)

There is a problem with the heat map. Shipping Cost 41364 shows in red instead of green. When you Select Square and increase the size, the size increases with all dimensions, not only the length.

This is exactly what I was looking for to complete my dashboard. Thank you!

Thanks for this video! New to Tableau and I thought it would be a little bit simpler to set up conditional formatting! Glad I have a way to accomplish my task now.

great tip, but major fail for tableau. after 10 releases, still dont have this basic excel feature

This video was extremely helpful! Thank you!

Great video is was very helpful. Is there anyway to right align the text within the dual axis? Usually financial numbers look better right aligned in a text table. Thanks!

Simple and easy to understand. Thanks

Thanks a lot! I was trying to figure this since a while! Very easy but smart trick :)

Great video. It helped me finalize a viz they way I wanted. Thanks again!

This was fantastic!!!👍😀👍

Yo, THANK you. So glad I watched this. Great stuff here.

Not exactly what I was trying to do, but still very handy! Thanks. (I was trying to set everything over 45 days to red and everything from 30-45 days to yellow, while still showing the number of days)

This is an awesome video ! Thanks so much !

THank you so much. Really helps a lot!!!

Can you please let me know how to get the alignment as right for the measure values in above kind of dual cross tab report? I went to format option for each measure and clicked right alignment, but it did not work.

Thanks for the upload - this is a very helpful work-around. I'm curious to know though if there's a way you could go about doing this while retaining the ability to sort by one of those columns?

Excellent Video. This helps :) thanks

thanks man.... saved alot of head banging

So clutch! Thanks!

What if I need to have a row-wise conditional formatting? That is, different color ranges for different rows?

Thank you very much. Thanks to this, I achieved something that others said was impossible :) There is only one thing: is it possible to give separate colors to the headers of these columns in a similar way?

Thank you for the informative video on conditional formatting. It was a a life saver. I was able to create the visualization using this trick but sone values show up indented to left while others are in the center. How can I fix this issue. Can you please help!

Thanks man! The Tableau forums are packed with some complex workarounds that are not as effective as your method.

Is it possible to get the grid lines as well?

Good evening and thank you for a very good tutorial. Can you assist me with the following error message? Cannot mix aggregate and non-aggregate comparisons or results in an IF statement. The calculated field is as follows: IF [InReportMonth] THEN SAT% END The calculated field for SAT% is; AVG (IF [SAT] = "Yes" THEN 1 ELSE 0 end) One of the things I am trying to do display is SAT for both InReportMonth and InPriorMonth, but unfortunately the error comes up. Thank you for assistance. David

Good video, thanks for the workaround. Anyone know if excel-style conditional formatting has been added as a feature in the current version? I'm running v 2019.1. What an ordeal to accomplish something so simple.

I'm afraid that there is some issue in the final highlighted shipping cost column. As the legend shows on the left it changes from $450 to $41364 ranging from red to green. But in the worksheets the shading of the $41364 is red. Actually I figured out that the shading is not that size, they are VERY LARGE squares and they overlap with each other. So how to solve this problem, thanks.

Now, how could I sort by column?

thanks for this

Hi Wonderful Video, Can you please update how to conditionally format the background color of the column ?

Video is awesome, but surely customer will come to me with a "but it's easier in MicroStrategy or Excel"... my face will go down. I'll have to be prepared. Thanks for the video anyway!

Hello, has anyone figured out how to change what data pops up when you hover over certain values in the worksheet? After completing everything shown in the video, I am now seeing every single column for the specific row instead of just the information for the specific cell I'm hovering over. Thanks!

Very handy, thanks. But, when I try to export the table as a CrossTab to Excel it takes a while to create the report and when the report is created the output does not resemble the crosstab view I have created in Tableau :-(

Hi, at 8:23 when you use square marks, some of the numbers which are in green gets converted into red which is wrong. For example, shipping cost $41k should be in green. Any idea how we can fix this.

I have 2 measures in the Attr(1) column. CAn i still bring coditional formatting for 2 different measures. ?

How come when I hold down the control key and drag the second value on to my column shelf it does not do what yours did. Does it matter if the values I am working with are calculated fields?

Nice Trick..

NICE!!!

Great video.. But if you see the last few steps.. The Shipping cost formatting is messed up due to the square size ... The one highlighted in green wasn't supposed to be green at all.. That green belongs to "Chairs and Chairmats" .. Basically the color and Text aren't in sequence .. :(

One thing that I noticed was that the color scheme for Shipping Cost does not match the values within the box. The color legend for Shipping Cost has a range of $450

How can I establish different width for columns?

Can't get the separator lines for the rows to show in the pane. Is there any way around this? Tried formatting, but no luck in getting the lines or the grey white bars across the rows.

Good video, but the resolution makes it a little hard to make out exactly what you're doing.

hi, can you tell how to change color of sheet !!

Great video. Thanks. But hopelessly complex to achieve a simple, common requirement. As every month goes by, Tableau is looking more like a dinosaur compared to PowerBI

hy, when i do totals for the colums the tableau coloring my totals and putting also the bar graph on thr total. can i cancel it?

why you changed to ATTR here ?

When you use the "square" mark, the squares overlap and therefore don't show the correct color to line up with each row...

I'm finding if I try to sort any column it just sorts based on the values of the first - is anyone else having this issue?

You need a lot of trickery to get this software to work. Seems like a new player can totally take over the market if they just make some software where everything is intuitive and this kind of stuff is not needed.

For those of you who only want to differentiate the metrics with specific color legends, maybe this video helps: kzfaq.info/get/bejne/nsdyra6Slsi0gas.html

This is a wtf moment