Button for MTD, QTD, YTD Sales?

[Anonymous]

Hi all,

is it possible to create a button that the end user clicks to show MTD, QTD, or YTD sales? I'd like only 1 to be able to selected at one time because the overlap may cause errors.

I know this will be formula driven, so I'm prepared to write these. But do you know if this is possible in concept? If so, how?

Thank you.

[Anonymous · Accepted solution]

Yes it is possible.  

There is similar discussion here: https://community.powerbi.com/t5/Desktop/Switching-Values-on-a-report-with-a-splicer/td-p/73389

And Avi Singh uses that technique and provides a sample .PBIX here: https://www.powerpivotpro.com/2016/08/watch-the-power-bi-webinar-recording-aug-16/

[Anonymous]

Thank you, this is exactly what I needed.