Show only the MTD, QTD and YTD buttons

Keep the period functionality while hiding headings, date inputs and extra controls.

A minimal three-button recipe

1. Under Slicers → Controls, turn Show filter section title and Show Clear all button Off.
2. Select the Date field; turn Show slicer title and Show Clear button Off.
3. In Date shortcuts, keep Show date shortcuts, Show Time Intelligence and Show MTD / QTD / YTD On.
4. Turn Show Date slicer, Show Calculate periods from, Show Relative Date periods, fiscal MTD/QTD/YTD, Quick periods heading, Time Intelligence heading and period instructions Off.
5. Optionally hide the applied range, container header and collapse control. Hide other fields with their Show slicer switch.

The Filter Box reduced to three filtering buttons.

Click to enlarge.

Hidden does not mean cleared

The saved Current Date/Slicer Selection basis still governs the buttons and is editable in the format pane. Hiding a heading leaves its controls available; an active period can be clicked again to clear its Date filter. Hiding/revealing text does not itself send filters or erase saved selections.

Back to the Knowledge Base