Forum Discussion
MichaelaMul
Helper III
Helper IIINeed Help- Want Line Graph with 2 Y-Axis Values with Legend
Hello, I am wondering if there's a way to make a simple line chart with the week as the X-Axis and the Y-Axis the Volume Sales and Volume Sales YA by Product. So you can see Private Label, Produc...
Sorry yes, what I ended up doing was the following: I went into Power Query and unpivoted the Vol Sales and Vol Sales YA data and then made a custom column to CONCAT the product name and the attribute name. Then I used that CONCAT name as the legend and the values column as the y-axis.
Thanks!
lbendlin
Super User
Super UserYou can either have a legend, or you can have two Y axis values, but not both.
One option is to use Small Multiples
The other option would be to modify your data to change the product column to include the CY/PY distinction
I kinda prefer the small multiples.