Slicer on Date dimension in Excel

• Jonathan Mallia

  SSCertifiable

  Points: 5192

  More actions

  July 28, 2014 at 7:03 am

  #150718

  Hi everyone,

  I just wanted to confirm with everyone that I am not missing anything and that this is the intended behaviour.

  I have created an SSAS cube with Date dimension and Date Hierarchy (Calendar Year - Quarter - Month - Day).

  When I add a slicer in Excel based on Year and Month, the Month slicer shows for example May-2013, Jun-2013, May-2014, Jun-2014... etc

  I know this behaviour stems from the way the hierarchy key column works, but is there a way to show the user just one Month for each Year?

  Thanks!