Forum Discussion

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