Creating Show/Hide filter for current week

[Anonymous]

Hello there,

I'm trying to create a filter to show or hide the current week from the visuals. It seems an easy problem but it has kept me stuck for a long time. 

Below is the graph where WK17 is the current week. The dip in the orange line is what I'm trying to provide a control to the user if they want to see that or not. 

I would like to create a filter that can hide only the current week or turn it back on. I would appreciate any help! Thank you!

[Anonymous]

@amitchandak Thank you for the response. I really appreciate the insights. The only concern is it will require me to create M2 for every M1. Just wondering if you have any other option that I can put to use.

Also, it was helpful to read through the articles that you shared. Now, it is causing me another trouble.

I created X-axis parameters : Daily, Weekly, Monthly, Quarterly and Y-axis parameters : M1, M2, M3, M4, M5.

The issue is whenever the X-axis selection is changed from one value (eg: Daily) to other value (eg. Weekly), the sorting just becomes random. Can you help with fixing the sorting of X-axis (ascending) for the X-axis parameter on changing selections.

Thank you!

[amitchandak]

@Anonymous , Few option. You can have measure say M1 and M1 till last week and use field parameter or bookmarks to ship

M1 = <You measure>

M2=

var _dat = today() -Weekday(today(),2)  // Monday week start

return

calculate([M1], filter(Date, Date[Date]<=_dat) )

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
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f