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

procyon82's avatar
procyon82
Resolver I
10 years ago

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?

 

uzGBDFP[1].jpg

procyon82's avatar
procyon82
Resolver I
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"))