Line and Clustered Column Chart

[ritanoori]

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?

[v-frfei-msft · Accepted solution]

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]

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