Line and Clustered Column chart YOY comparison

[pvural]

Hello everyone

I can't create this simple chart in PowerBI that I've used in Excel for years.

I created cumulative sales to use on the lines, however cumulative appears as sum of 2016 and 2017 (see below), as opposed to two different lines for each year.

Thank you in advance! 

Petek

[v-shex-msft · Accepted solution]

HI @pvural,

Based on test, current 'Line and Clustered Column chart' not support auto analysis your measure and generate multiple lines of each category.

For your requirement, you need to manually write multiple measures for each category or try to submit it to ideas forum.

BTW, if you switch your visual to matrix, it can drill your measure to each categories.

Regards,

Xiaoxin Sheng

[pvural]

Hello @v-shex-msft 

I accepted your multiple measure offer as the solution. Just adding the year specific DAX for those who are interested.

2019 Gross Sales (YTD) = CALCULATE(SUM(YourTable[GrossSales]),FILTER(Date,Date[Year]=2019))

Best regards,

Petek

[pvural]

Thank you for taking the time to respond. It is a little bit frustrating when you can not duplicate simple things you do in Excel.

Regards,

Petek

[v-shex-msft]

Hi @pvural,

>>It is a little bit frustrating when you can not duplicate simple things you do in Excel.

Yes, current there are some differences between excel dax formula and power bi dax formula. They all has the specific functions which only work on themselves.

Regards,

Xiaoxin Sheng