Clustered column and line - Y axis line not working

[Sedos101]

I am trying to display the legend for the line y- axis as the same as the column legend.

However my line only has two points (the average for the Analysis model column) and not one for each Hauler name as seen in the table below the chart...

Any help would be greatly appreciated

Thanks 

[Anonymous]

HI @Sedos101,

Did you mean to show the y axis with right-angle styles? If that is the case, you can find out the 'lines' property in the 'format' panel and turn on the 'stepped' option, then these lines will be displayed in a similar style as your bars.

Notice: if you are working with the old format panel, you can find this option in the 'shape' option.

Regards,

Xiaoxin Sheng

[Sedos101]

@Anonymous Hi, sorry

What I mean was I cannot show individual values for the Y-Line. 

See how I have individual values for the Y- Column

I want the same for the Y-Line

However it averages the Y-Line by the X-Axis?

[Anonymous]

HI @Sedos101,

Yes, the chart will show aggregate value instead of split into multiple lines based on current legends.
They are basic features and you can't do custom with this, perhaps you can try to use script-based visual(R, Python) to manually plot these graphs.

Create Power BI visuals using R - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng