Secondary Y axis not working

Hi  Julia_Mav ,

I created some data:

If you use legend, you cannot add the secondary values.

You can choose different visuals, such as Line and clustered column charts, with one Value displayed as a bar chart and one Value displayed as a line chart.,

Another approach is to create a separate measure for each value in the Legend field.

Create measure.

MeasureA_Amount =
SUMX(FILTER(ALL('Table'),'Table'[Group]="A"&&'Table'[Date]=MAX('Table'[Date])),[Amount])

MeasureA_Amount2 =
SUMX(FILTER(ALL('Table'),'Table'[Group]="A"&&'Table'[Date]=MAX('Table'[Date])),[Amount2])

MeasureB_Amount =
SUMX(FILTER(ALL('Table'),'Table'[Group]="B"&&'Table'[Date]=MAX('Table'[Date])),[Amount])

MeasureB_Amount2 =
SUMX(FILTER(ALL('Table'),'Table'[Group]="B"&&'Table'[Date]=MAX('Table'[Date])),[Amount2])

Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly