Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Line and Clustered Column chart YOY comparison

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 s...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Anonymous,

     

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Anonymous 

 

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