Specific line on top in a line chart

[#1]

Hi all,

I made a line chart with race info of a Swimming race. There are lines for all 8 swimmers in the race and the red line is my selected person.

Cseh's line is not plotted as top line, all other lines are plotted above the red one. I can change the sortation from Page at the top to Cseh at the bottom, which gives me this view.

However I don't like this sortation to the right. I want my selected swimmer on top and the rest can be sorted by their Rank. Does anyone have an idea how I can choose which line has to be on top without changing the sortation on the right.

Thanks in advance!

Vincent

[Jason_Michaelides]

I think I've recently done something similar. Can you post a sample of your app?

[#3]

Here you go

[Jason_Michaelides]

Is 8 always the maximum number of lines?

[#5]

For this specific analysis yes, but it would be nice if it is a solution that works independent of the number of lines.

[Jason_Michaelides]

Hmmm...I'll have a think.  I have used FirstSortedValue() to dynamically create multiple expressions in a particular order before which worked pretty well, but you had to create enough expressions to deal with the maximum number you'd need.

[#7]

I have solved this by using a ARGB() statement for the color of the non-selected swimmers, which will make these lines transparant.