Overlapping lines, change display order

[Anonymous]

On a Line and Clustered Column Chart, I have 2 lines that mostly overlap.  I want to bring one line to the front and overlap the other.  I've tried to change the ordering in the 'Line Values' section but it does not change.

How do I change the overlapping order of lines on a Line and Clustered Column Chart?

[stevemcgrath]

I had the same problem and found a hack solution (I googled and found your post, then played with a few things). The order of overlap depends on the order you drag measures into the 'Values' section of the visualisation.

Drag everything out to the 'Tooltips' section just beneath it, then drag them back into 'Values' in the order you want, back to front.

[tmendoza]

That did it!

[Cmcmahan]

Ah, that makes sense, because when I would drag things out, I would remove them entirely, and then go back and pull them from the fields pane.  Nice fix Steve!

[Anonymous]

Thank you for your response, I thought I posted this image earlier.

Here is an example of the chart I am working with.  I want the red line to be more prominant than the yellow line.I want the red line to overlap the yellow line. I dont really want to change the line weight or shape of the line.  Is it possible to make that change?

[Cmcmahan]

I might be mistaken, but I believe you can do this by re-ordering the source values in the Visualizations pane.

[Anonymous]

For the chart shown.  Changing the order in the visualization window did not change the ordering.  I tried using the June '19 update of Power BI.

[Cmcmahan]

Huh. When I swap them, they swap colors and which one shows up better on top.

You may be able to go into Shapes>Customize Series ON> turn the line style of your yellow line to dashed or dotted to emphasize it's less important then.  Or increase the stroke width of the red line by 1.  It's not a lot, but it will make it pop.

[tmendoza]

@Cmcmahan ,

Trying your method out, this does not seem to work.

Have you had any luck finding other solutions? I'm having the same exact problem with the line charts.

[v-piga-msft]

Hi @Anonymous ,

I'm not clear what's mean of "bring one line to the front and overlap the other". 

If your have have 2 lines that mostly overlap, what about setting with different color to identify them like below?

Best Regards,

Cherry