SWITCH function MTD / YTD applied to multiple measures

[Anonymous]

Dear Community, 

I am trying to set a switch function between month and year that would applied to graph containing :

- Sales TY

- Sales LY

- Sales TY vs LY variance %

How can I create a function that allows the swithc to apply to these multiple measures?

Thank you in advance for your help.

Kind regards

[Jihwan_Kim]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below.

All measures are in the sample pbix file.

In this case, I suggest creating a separate table for a slicer, like the below picture.

https://www.dropbox.com/s/gl2m0y0zid9eohw/mb.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Anonymous]

Hello @Jihwan_Kim , thank you for your kind help but this is not exactly what I needed. I wanted to have a sales measure with MTD / YTD switch, that would apply to my visualisations that are including at the same  time Sales TY, LY and TY vs LY. I managed to solve it. Thanks a lot! 

[amitchandak]

@Anonymous , Seem like you are lloking for measure slicer

My video: https://www.youtube.com/watch?v=b9352Vxuj-M

Others
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern 

[Anonymous · Accepted solution]

Hello @amitchandak  , thank you for your kind help but this is not exactly what I needed. I wanted to have a sales measure with MTD / YTD switch, that would apply to my visualisations that are including at the same  time Sales TY, LY and TY vs LY. I managed to solve it. Thanks a lot! 

[oscarca]

How did you solve it ?