Forum Discussion

ritanoori's avatar
ritanoori
Resolver I
7 years ago
Solved

Line and Clustered Column Chart

Hello everyone, I'm trying to build below chart in power BI. I need to have PY values, then CY year break down by quarters. Noting that Yearly Average is coming from a column in a table that is different from quarterly Average colmn in the same table.

 

Any ideas please?

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi ritanoori,

     

    One sample for your reference.

     

    1. Create a date table and create relationship between it and the fact table.

     

    Table = CALENDARAUTO()

    2. Create the measures as below.

     

    Average = CALCULATE(AVERAGE(Table1[value]))
    Measure = CALCULATE(SUM(Table1[value]),SAMEPERIODLASTYEAR('Table'[Date]))

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

     

     

     

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi ritanoori,

     

    One sample for your reference.

     

    1. Create a date table and create relationship between it and the fact table.

     

    Table = CALENDARAUTO()

    2. Create the measures as below.

     

    Average = CALCULATE(AVERAGE(Table1[value]))
    Measure = CALCULATE(SUM(Table1[value]),SAMEPERIODLASTYEAR('Table'[Date]))

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

     

     

     

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi ritanoori ,

       

      Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

       

      Regards,
      Frank