Secondary Axis showing as Off even though it's clearly on

[wynhopkins]

I added a simple column and line chart to display Actual v Target

Couldn't work out how to get the line to show on the same Axis as the column because the formatting option said the Secondary axis was off (see image)

Toggling the switch on and off fixed my issue

[v-chuncz-msft]

@wynhopkins 

I tried the latest version and it seems to work fine for me. Recreate the visual and raise a support ticket for assistance if necessary.

[wynhopkins]

Could you try again with this data set please

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("ZZA9C8IwEIb/S+YKl8tdLjcK4iBUB8fSoZbiIrWIFfz3polUiNvLPXnuI01j6u69sWoqgwCMSDGZtmrMYR5z3SoBE/zqt/I9JLCdryXgQMwsCZ+Hqexn1XuljE/9s7TRUkDN+Hh/lXaeuhv6P49iX9K8bTduMM9SFfJLEiGWkPB+uHxxEBCXkoeghAnX3aO0MW4l6PPF04odowvrUsufFp4jC8LRaz8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Month Year" = _t, #"Gas Target Consumption" = _t, #"Gas Usage MJ for Month" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Month Year", type date}, {"Gas Target Consumption", Int64.Type}, {"Gas Usage MJ for Month", Int64.Type}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Gas Target Consumption", "Target"}, {"Gas Usage MJ for Month", "Actual"}})
in
    #"Renamed Columns"

Date	Actual	Target
May-19	2005224
Jun-19	1940540
Jul-19	2005224	0
Aug-19	2005224	5845557
Sep-19	1940540	1966947
Oct-19	2005224	2148297
Nov-19	1940540	0
Dec-19	2005224	2496649
Jan-20	1999746	1774578
Feb-20	1870730	1608942
Mar-20	1999746	2214726
Apr-20	1935238	0
May-20	1999746	3410756