Forum Discussion

Tontaube's avatar
Tontaube
Frequent Visitor
8 years ago

last year on x-axis column chart

Hi,

 

can anybody tell me what I do wrong? I want a column chart to show the values of the year before the one I sliced on.

 

I´ve created a calculated column "vorheriges.Jahr = (DCW[Zeit.Jahr])-1", formatted it the same as the current year, adjusted the filters - yet the column doesn´t show the correct values.

 

On a sidenote: How do I show the values behind the columns on the column chart, but a little bit transparent? A second diagram behind the first one, or is there a more elegant solution?

 

Bye

 

Michael

3 Replies

  • Tontaube's avatar
    Tontaube
    Frequent Visitor
    8 years ago

    Sorry, double-posting due to not realizing that the email has to be verified...

    • Tontaube's avatar
      Tontaube
      Frequent Visitor
      8 years ago

      Hi,

       

      can anybody tell me what I do wrong? I want a column chart to show the values of the year before the one I sliced on.

       

      I´ve created a calculated column "vorheriges.Jahr = (DCW[Zeit.Jahr])-1", formatted it the same as the current year, adjusted the filters - yet the column doesn´t show the correct values.

       

      On a sidenote: How do I show the values behind the columns on the column chart, but a little bit transparent? A second diagram behind the first one, or is there a more elegant solution?

       

      Bye

       

      Michael

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Tontaube,


    You can create a similar measure as follows in your table, then create a clustered column chart as shown in the following screenshot.

    Sales last year = CALCULATE(SUM(Sales[SalesAmount]),SAMEPERIODLASTYEAR('Calendar'[DateKey]))





    Regards,
    Lydia