Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Combo line & clustered chart does not work

My dataset looks like the following and I am trying to build a chart like the first picture below. I tried using the line & clustered column chart (2nd picture), but the issue is that the columns for the same month this year & last year are not together, and the prices of SKU 1 and SKU 2 are not on top of each other. It there a different chart I can use, or can I manipulate the data in a way that makes it possible? I tried duplicating the table, but I can't seem to make some columns/lines refer to one SKU and the others refer to another SKU. Thanks a lot!

 

SKUYearMonthVolumePriceDate
SKU 120201200451/1/2020
SKU 120202210462/1/2020
SKU 120203189453/1/2020
SKU 120204120454/1/2020
SKU 220201300451/1/2020
SKU 220202250462/1/2020
SKU 220203204433/1/2020
SKU 220204350454/1/2020
SKU 120191120441/1/2019
SKU 120192126442/1/2019
SKU 120193200433/1/2019
SKU 12019472434/1/2019
SKU 220191360441/1/2019
SKU 220192300422/1/2019
SKU 220193200433/1/2019
SKU 220194420444/1/2019

 

Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    In you scenario, we should create measures to work on it.

    sk1 = CALCULATE(SUM('Table'[Volume]),FILTER('Table','Table'[Year]=2020 && 'Table'[SKU] = "SKU 1"))
    SK1 LY = CALCULATE(SUM('Table'[Volume]),FILTER('Table','Table'[Year]=2019 && 'Table'[SKU] = "SKU 1"))
    Sk2 = CALCULATE(SUM('Table'[Volume]),FILTER('Table','Table'[Year] = 2020 && 'Table'[SKU] = "SKU 2"))
    Sk2 ly = CALCULATE(SUM('Table'[Volume]),FILTER('Table','Table'[Year] = 2019 && 'Table'[SKU] = "SKU 2"))

     

     

    Pbix as attached.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      @ 

      Thanks for your response. The issue is that I'd like to use slicers for the two SKUs, so they shouldn't be hard-coded into the measures.