Clustered Column Chart With Line On Secondary Axis. Sep 26 2018 Then click Charts. In excel 2016 by default Excel will suggest you use a chart with a secondary axis.
Data -- currently row 3 in the spreadsheet -- into your charts secondary Y axis. In Power Bi for the primary y-axis we can just turn on the grid lines option to get the grid lines but theres no option for the secondary y-axis. Click OK to insert the chart.
Under Choose the chart type and axis for your data series check the Secondary Axis box for each data series you want to plot on the secondary axis and then change their chart type to Line.
However in the tool when I select from Visualization pane Y-Axis then Show secondary nothing happens. Click the Insert tab. -- the first option as shown below. I need grid lines for the secondary y-axis ie.
