I think I have done something similar lately. But my method was a lot simpler. Do you wanna try dropping your initial Switch measure in the Drill through from then change Drill through when the measure is summarised? Basically you want the drill through page to action based off a measure instead of a field from the dimension table. This should work.
Thanks for the idea. there are many different approach to get the solution working. In this approach, the first switch measure is not useful in drill through field
Time intelligence functions, by default shows MTD QTD and YTD for the selected Dates in the context. you can also modify it if required. I have posted few more videos on this topics, please check it out.
I think I have done something similar lately. But my method was a lot simpler. Do you wanna try dropping your initial Switch measure in the Drill through from then change Drill through when the measure is summarised? Basically you want the drill through page to action based off a measure instead of a field from the dimension table. This should work.
Thanks for the idea. there are many different approach to get the solution working.
In this approach, the first switch measure is not useful in drill through field
Very useful tutorial. Thank you so much for this 🙏
Glad it was helpful!
Great tricks. Thank you 👏
You're welcome!
excellent
Thank you! Cheers!
❤
How can I show the value for MTD,QTD,YTD upto selected month or date seperately in power bi
Time intelligence functions, by default shows MTD QTD and YTD for the selected Dates in the context.
you can also modify it if required.
I have posted few more videos on this topics, please check it out.
Can you please share this Power bi file? Or data?
Thanks for watching. to get the PBIX file used in the demo, Please send an email by mentioning the video title as email subject.