Sounds like a Table Calc might help here -- how familiar/skilled with Table Calculations are you?
Basically, you'd need to operate your calc within the pane, using some sort of WINDOW_ function, but that can get tricky if you're not sure what I'm talking about:
Different ways to do this. Here is my approach based on pivot.
Create a calculated field to color.
Place this to color. You can make it continuous to get a sequential color range.
Let me know if that helps or not.
example formatting.twbx 17.1 KB
As I'm not sure if I was understood correctly (probably partially), that's why i constructed this awesome excel example of what I mean:
Measure1 conditional formatting is what I have now
Measure3 to the right is what I want to achieve
So I want to use conditional formatting (not discrete!) dividing it per GROUP or any other category I might have. so this formatting is set separately for group A, B and C.
In example Measure1 you can see that it's just one conditional formatting and number 1 has most red color, number 75 has most green color.
In Measure3 example this is different. For group A number 1 is red, 60 is green, but in group B, as the lowest nubmer is 50 - this number is red, and 52 as a max - is green.
Thanks in advance!
PS - i cant use pivot tables and I must have this dynamic, not choosing colors for each number separately
Wow, this really is a workaround haha..
It works! Thanks. One more question - how to change values to percentage while they are a text value?
Glad I could make it work
What exactly do you mean, change to percentage while they are text?
Do you mean tableau reads it as text (ABC) from your datasource?
Or do you want to show it as percent of total?
I have few metrics, lets say one is Clicks and one some kind of aggregation like clicks / impressions, so I wanna show the second metric as a % format and not numeric