cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

 

Line and Column Secondary Axis Off.jpg

Status: New
Comments
Community Support

@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.

 

MVP

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"

 

DateActualTarget 
May-192005224  
Jun-191940540  
Jul-1920052240 
Aug-1920052245845557 
Sep-1919405401966947 
Oct-1920052242148297 
Nov-1919405400 
Dec-1920052242496649 
Jan-2019997461774578 
Feb-2018707301608942 
Mar-2019997462214726 
Apr-2019352380 
May-2019997463410756