1 of 1 people found this helpful
Here is one way to do that
go to the color tile and Edit Colors - then Advanced and in the lower portion of the box you can set the color range -
Do the same on each you your worksheets and it will lock the color scale
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
BTW Welcome to Tableau
Glad to help out
Picking up an old thread here, but is there a way to do this without hard-coding the start and end values of the color range? Ideally you'd want to be able to use calculated fields here like you can with reference bands. The problem I'm trying to solve is to use a consistent color range across multiple worksheets where each worksheet is filtered to a subset of the data. I need the color range to look at the entire data set rather than the filtered data but need to do it without hard-coding the min and max values because I require the flexibility to use the same workbook with different (but similarly structured) data sources which would have different min and max values.