Line and Stacked Column Chart with Slicer

[procyon82]

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:

Selecting 2 years:

[Seth_C_Bauer]

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

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

[Seth_C_Bauer]

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. 

[procyon82]

I don't think that's the case. I think it only draws a column on the first day of the month.

Here's what it looks like when you select 2014 and 2015, but I applied a filter to only select January to March for each year to filter out our year end spikes. I also removed the line to make sure that wasn't the problem. I noticed it goes down to 'per day'. Any clue why it is doing that?

[procyon82 · Accepted solution]

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