Yes. We can set the same color for two different dimensions. We should not directly drag and drop both dimensions onto the color. First drop one dimension on color shelf after that bring another dimension into the level of detail first then select color from options.
I was meaning using the:
Default Properties - Color
selection on the dimension itself, it just takes you to the colour selection and you cannot see all the values for the dimension, I want to select one colour for all then select two or three to be different.
1 of 1 people found this helpful
We cant do that in the default properties section. But if there are only two or three different values that has to be colored different, then we can create a calculated field and group it into 2 or 3 then bring this field on to 'color' in marks card.
This should meet your requirement.
Thanks for that. Good to know.
As mentioned @sai using a calculated field is a good way to color specific rows of a dimensions.
I created a calculated field "Coloring subcategory" :
IF [Sub-Category]="Art" THEN "blue"
ELSEIF [Sub-Category]="Chairs" THEN "red"
ELSEIF [Sub-Category]="Paper" THEN "green"
See in workbook attached.
coloring with calc field.twb 217.2 KB
That's a better way, thanks. Should have thought about that as I already had something similar at the next level. It was because I had one of the values varying that I was trying to assign to loads of values. I've just duplicated the variable I had and put in a fixed value to have a default colour for. Works fine.