Here is yous solution. We can do conditional formatting for individual row. PFA for solution.
Helpful Link: Tableau: Advanced Conditional Formatting - YouTube
**IF issue resloved, close the thread
179349_SMK.twbx 1.2 MB
Tableau can do conditional formatting but not to the level of detail as Excel (for example) where you can easily format at cell level. In Tableau formatting works well on a range, but for more individual formatting you need to hack...
Sai's reply is closest to the route I think you'll need to take... here is a blog posting explaining it in more detail:
Basically you use a MIN(1) field to create a grid matrix which can be used to give more specific formatting options to cells/ rows/ columns.
Best of luck!
From what I have been reading Tableau does not have the same formatting ability as Excel.
Yes! But the entire row.
Yeah, I don't know if this would exactly work for you. Really this is a one off kinda thing.
How many columns do you have/how many different measure? If it isn't too much than we can use conditional formatting and some calculated fields to kinda make it look correct?
But I highly doubt this is a sustainable solution.
In some cases as many as 12.
Yeah, than this won't really work. It would, but it would be a real hassle, and want look the way you want.
Tableau isn't meant to be EXCEL, so don't try to force to be. Is there a way you can present your data graphically ?
Slowly learning that.
do you have a packaged sample workbook to post? I have used a workaround technique to create colors on specific lines irrelevant of the displayed data values.
The way I have gone about this:
1. Month on the column shelf, proof point on the row shelf.
2. Place the metric value onto the label.
3. Here's the "trick"
- use a surrogate calc (in my case variable "one") to specify for specific metric_id's (which by the way are not shown on the viz) to apply the color and size. I use decimals (within the calc) that are very similar to each other, but not enough to make a difference in the width of the color. And then I assign the color of green, yellow, red to the decimal values.
when 7 then .0111111
when 11 then .0111111
when 12 then .0111111
when 101 then .0111111
when 102 then .0111111
when 103 then .0111111
when 104 then .0111111
when 27 then .0111111
when 28 then .0111111
when 37 then .0111111
when 38 then .0111111
when 47 then .0111111
when 48 then .0111111
when 53 then .0111111
when 54 then .0111111
when 68 then .0111111
when 70 then .0111111
when 31 then .01111111
when 9 then .0111111111
when 10 then .0111111111
Not exactly what you need but this could be one way of doing it. You can create a formula like,
IF [Category] = 'Furniture' THEN 'Large' ELSE 'Small' END
Place this calc on 'size' on the marks card. You may have to edit the sizes. Make everything bold but decrease the transparency on the color to about 75% so that the small sizes (the ones you don't want bolded) look a little less prominent on the view.
Brilliant workaround Pooja!
Never thought about making everything BOLD and then just downgrading the Transparency.
I'll have to remember this one for 'one-off' tips and tricks.