Unable to change color in line and clustered column chart

[ifaber]

Hi dear community,

im  not able to change the color of lines in a clustered line and column chart. The option to choose a series is just not available, although I have two data fields as Lines.

Does anyone knows howo to solve that?

Thanks alot in advance!

[Bibiano_Geraldo]

Hi @ifaber ,

Try to take out the measures from the visual or build other, and paste the measures one by one checkik if the series goes disables, ti identify if the problem if with some measure in your visual, i just replicated your scenario here and it works perfectly:

[ifaber]

Hi @bchager ,
Sure, here are the expressions: 

Margin % = DIVIDE(CALCULATE( 'Measures Sales'[Margin]), CALCULATE('Measures Sales'[Revenue]))

Margin % PY = CALCULATE('Measures Sales'[Margin %], SAMEPERIODLASTYEAR('Dim Date'[Date]))

[bchager]

@ifaber Yes it looks like the visual can't make a distinction between the 2 measures. You can test that by removing one from the Line y-axis and replacing it with a measure or calculated column that references a field other than Margin.

[ifaber · Accepted solution]

@bchager thank you for your quick response!

I've tried multiple fields now, it just doesnt work.
If I build the visual from scratch it works though. So I guess I need to rebuild each Line Chart in that report.

[bchager]

@ifaber It could be because you're using the same series for each line. Can you share the expressions for each?