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])-...
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