It looks like you want to color part of a bar blue, and the rest red? If not, can you mock up what it would look like?

Good Morning Ayush.

Attached is workbook that does what you're looking for. It's a dual-axis bar chart that uses this formula to produce the blue bars:

IF SUM([Sales])<400000 THEN SUM([Sales]) ELSE 400000 END

It looks like this:

Make sure you sync the axis or it won't work correctly. Also you can bring the blue to the front by re-arranging the color legend (if necessary).

--Shawn

You can use the Measure Values:

It gets a little tricky/busy but doable. (See Attached.)

--Shawn

It's the same idea. Use Measure Values to include a duplicate of the Sales field. You calc on the dup would look something like this:

IF SUM([Sales])>400000 AND SUM([Sales])<1000000 THEN SUM([Sales]) ELSE 1000000 END

Results in this:

See Attached.

--Shawn

Nice job Shawn. For some reason I was stuck in padding the data out to get two marks.

Ayush, you may want to also consider reference bands as well - http://onlinehelp.tableausoftware.com/v7.0/public/online/en-us/reflines_addbands.html

Then you could have as many colors as you like

Ayush, you're right using Measure Values to add the third color messes up the totals. Maybe Alex will have an idea of why and how to fix this. I'm off for a bit chasing down gremlins of my own.

--Shawn

Using Shawn's method of stacking the bars with separate measures, we can dispense with the double axis and tweak the formulas a little. Note the order in the Measure Values Shelf is important:

Yep that's it. Nice work Alex. Thx.

--Shawn