Forum Discussion

Anonymous

Not applicable

3 years ago

Creating Show/Hide filter for current week

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 ...

Icon for Super User rank

Super User

3 years ago

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