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 sum of 2016 and 2017 (see below), as opposed to two different lines for each year.

 

 

 

 

 

Thank you in advance! 

 

Petek

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

4 Replies

  • 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Anonymous,

         

        >>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