Forum Discussion

procyon82's avatar
procyon82
Resolver I
10 years ago
Solved

Line and Stacked Column Chart with Slicer

Hi,

 

Can somebody tell me what I am doing wrong. I am using the Slicer with the Line and Stacked Column Chart and whenever I select more than 1 year it creates skinny columns (see second screenshot). The line is using SAMEPERIODLASTYEAR(Ecommerce[Date]) to show last year's revenue.


Selecting 1 year:

jm5vuPu[1].jpg

 

Selecting 2 years:

2eerm2Z[1].jpg

Need Help
  • procyon82's avatar
    procyon82
    10 years ago

    I figured it out.

    I used.

    Month Year = DATEVALUE(FORMAT([Date],"MMM-YY"))

     

    Changed it to the following fixed it!

    Month Year = DATEVALUE(FORMAT([Date],"MMM-YYYY"))

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    procyon82 The issue isn't the selection of the second year, the issue appears to be the final result. It spikes so far off the scale of the other values, so in order to accomodate, the graph shrinks.

    • procyon82's avatar
      procyon82
      Resolver I
      10 years ago

      I understand that part. What about the width of the columns? That's what I am questioning...

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Staff or Admin will probably be able to give you a better answer, but it is most likely just an internal scaling mechanism due to the spike.