Forum Discussion
MTD/YTD Time Intelligence Buttons
Katia1688 You should be using that measure in whatever visual you want the time intelligence value to display. I don't see any logic in adding it to a filters pane or as a filter to a slicer, that doesn't make any sense.
Thank you Greg. Do you have any suggestions for activating the buttons?
Katia1688 I would use a slicer and set it to horizontal. Provides the feel of buttons without being actual buttons. If you wanted to use real buttons, it's possible but involves quite a bit of work and trickery with the Bookmark and Selection panes. Basically, you put the slicer on the page. You create a bookmark for each button you want. When you create the bookmark, select the slicer and select the option your want. Create your bookmark such that it only impacts the selected visual (the slicer). Hide the slicer in the selection pane and update your bookmarks. You then tie each button to one of the bookmarks created. Now your buttons activate a bookmark which changes the hidden slicer on the page. It's a real pain but should work.