I've been using a solution when custom colouring measures in a bar chart (see "How to set custom colors by measures in a bar chart") which was created by this guy called Ian Wilson. It's been working just fine. However, now I'm trying to do the same thing with a line chart, but it doesnät work. It's s if the expression seems too complex or something. Take a look.
I have 2 dimensions; Month and Type. In the Type dimension I created a valueList to create temporary dimension andI wrote it like this: ValueList ('Result', 'Revenue PY', 'Budget').
MEASURE! The measure I have is called Amount and the expression I wrote is:
Okay, so I managed to kind of change the colours on the line chart, but I'm not fully satisfied. This is what the Line Chart looks like when it's with standard colours:
And this is what it looks with my customized colour:
As you can see, only the lines get the colours. I can live with that, but what's strange is that if I choose a month, all the other months look like this:
The other months and their lines get the same value as the "result" amount, which is weird. I've looked through the expressions, but they look fine. Is this something that sometimes can happen when trying to customize colours?