cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhanson41 Member
Member

Button for MTD, QTD, YTD Sales?

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Steve_Wheeler Established Member
Established Member

Re: Button for MTD, QTD, YTD Sales?

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/

2 REPLIES 2
Steve_Wheeler Established Member
Established Member

Re: Button for MTD, QTD, YTD Sales?

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/

Highlighted
bhanson41 Member
Member

Re: Button for MTD, QTD, YTD Sales?

Thank you, this is exactly what I needed.