Forum Discussion

FerrariGolf's avatar
FerrariGolf
Frequent Visitor
2 years ago
Solved

Same line colour based on higher level

Hi. I hope I am able to describe what I need correctly (I'm very new to Power BI and table relationships).

 

I have a line graph (X-axis is log scale and inverted) with 'Grainsize' on the X-axis and '% Finer Than' on the Y-axis. The lines are separated based on an ID. There can be multiple ID's within the 'StratumDetails'.

 

Currently, the colours of the lines change for each ID. However, I'd like to have the colours be the same for each StratumDetails. Is this possible? Please see pictures and hopefully it all makes sense.

 

In the first picture, there are 5 lines (all under Zone 3 Tailings) and they are all different colours. In the second picture, there are 3 lines (all under Mixed Zone) and they are all separate colours. What I'd like to have is all of the Zone 3 Tailings lines be one colour, and all of the Mixed Zone lines be a separate (but same as each other) colour. Same for all other 'StratumDetails'.

 

Both fields are dynamic so I can't just manually edit the colours to match.

 

Thanks in advance.

 

2 Replies