Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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!
Hi, @marinearri
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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!
@marinearri , 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/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
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!
How did you solve it ?
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |