Forum Discussion

Coffee1234's avatar
Coffee1234
New Member
2 years ago
Solved

Dynamic Slicer Quarter, Month

Hi,   I am building a dashboard which shows goals for each month.  My goals table looks something like this  Store Number      Month      Goal      Quarter 1      January      $10    ...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Use a proper calendar table with Date, Month, Quarter and Year columns.  Add Year, Quarter and Month to a slicer , which will create a hierarchy for you.  Or use the built-in date hierarchies  (not recommended).