Forum Discussion
Julia_Mav
Helper II
Helper IISecondary Y axis not working
Hello all, I am trying to build a simple line graph that shows two y axis - Actual & Plan (see the picture attached). However, when I am trying to add the Plan value in the secondary ...
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
First remove the legend. Remove the X-Axis date. Put the value first in primary Y axis then Secondary Y axis and then put Date. See if that works.