Forum Discussion

Anonymous's avatar
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 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!

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    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

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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!