Are you able to provide an example workbook or even a screenshot showing the fields in the view?
I suspect this is because you are using measure names/values to build the table? When that happens, the colour scheme applies to all measures on the same row.
However, this may not be your setup, so if you could provide a screenshot, that would be great (a picture tells a thousand words and all that)
1 of 1 people found this helpful
The reason is because each unique value of a dimension gets a different colour, so as the number changes, the colour it matches will too. The simple way to change this is to have a calculated field like this:
IIF(LEFT([New Video_Status],1)="-","Negative",IIF(LEFT([New Video_Status],1)="+","Positive","Created"))
Then use that on the colour shelf. The colours won't change then.
Thanks Andrew, that fixed my problem