Forum Discussion
show filter datas based on slicer selection
Hello All, I have report having data like below for last 400 days. Date Sales 1/1/2022 100 1/2/2022 200 1/3/2022 300 1/4/2022 34 1/5/2022 78 1/6/2022 56 1/7/202...
amitchandak
Super User
Super UserAnonymous , Try what I show in blog
https://medium.com/chandakamit/power-bi-when-i-felt-lazy-and-i-needed-too-many-measures-ed8de20d9f79
Or create three measures and use field parameters
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
Rolling Days Formula: https://youtu.be/cJVj5nhkKBw
Rolling Months Formula: https://youtu.be/GS5O4G81fww