Forum Discussion

MichaelaMul's avatar
MichaelaMul
Helper III
1 year ago
Solved

Need 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...
  • MichaelaMul's avatar
    MichaelaMul
    1 year ago

    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!