Forum Discussion
SWITCH function MTD / YTD applied to multiple measures
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
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!
5 Replies
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-patternHello 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!
How did you solve it ?
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
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!
