Same line colour based on higher level

[FerrariGolf]

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.

[amitchandak · Accepted solution]

@FerrariGolf , As of not we can do conditional formatting on line visual. Also when we use multiple measures and legend

[Ritaf1983 · Accepted solution]

Hi @FerrariGolf 
As @amitchandak  there is no generic option to achieve the desired result.
I found a workaround to do it manually you can see the tutorial and the file that I created in the linked discussion:

https://community.fabric.microsoft.com/t5/Desktop/Require-help-in-plotting-a-chart/m-p/3595787#M1181...

but I'm not sure that it can be useful when you have many categories and groups like on the images that you attached

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[amitchandak · Accepted solution]

@FerrariGolf , As of not we can do conditional formatting on line visual. Also when we use multiple measures and legend