Forum Discussion
Last 3 Months Slicer
Super UserDid you try the relative date slicer of the new release of power bi? It is a preview feature you have to activate in power bi desktop. That is the only aproach to have only one column specify as you need.
You can read more in the release notes:
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/#relativeDateSlicer
Regards, hope this help or you may need more columns I think.
Yes, it`s working acceptably but I wanted to build more flexible slicer based on data I am providing. For instance, no day drill option when I have only month-based data. By relative date slicer it`s not possible.
thank you for your ideas anyway!
Jakub
Dear Anonymous,
Have you try What-If parameter?
You can create new Parameter type Number, it'll use for selected number and refresh data with last 1,2,3,....9 month.
Parameter Value = SELECTEDVALUE(Parameter[Parameter], 3)
Then make measure, filter it by some Operation with "Parameter Value".
Topic about Parameter: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/#whatIf
If you need a day drill option, you can use Custom Visual "TimeBrush". You can drag mouse to select a range or move it.
Hi Anonymous,
Thanks for your suggestion! I`ll try it out and let you know if that works fine for me :)
Greetings,
Jakub
Dear Anonymous,
Sure, I'm waiting for your result. If you get problem, we can discuss more :)
Regards,
ManNVSM.