Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Problem with Date Visual Filter not updating

Hi Community

 

Having an issue with a Visual Filter not updating DATES on the Teams tab or within Workspace online. However, it does update when I open the project (without refreshing) in the Desktop app. I've refreshed the data and the week numbers do not update. 


The VF is a list of 4 weeks +"Current Week", using a calculation within a CALENDARAUTO( )

"Relative Week", IF( WEEKNUM( [Date], 21) = WEEKNUM( TODAY(), 21), "Current Week", YEAR ( [Date] ) & "-" & FORMAT(WEEKNUM([date], 21),"00") )
 
I've attached the images from Workspace and Desktop to show this
Workspace / Teams view

Teams channel Tab

 

Desktop App

Desktop app

 

How do I get the VF to update with the current week showing and weeks 1-4?

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Not very clear.

    In the Desktop App calendar table should get updated. Other tables will update with refresh

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Anonymous ,

     

    Is there any other filter in Power BI Workspace on this report page? Because if it is right in Desktop then it should show same in Power BI Service.

    Also, have you tried re-publishing your dashboard to Power BI service and then checking?

     

    Thanks,

    Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi all,

     

    Sorry this was my confusion, the PBI Service is updated on a Sunday evening, ready for Monday morning. Therefore the model hasn't moved into the next week yet (Monday), I need to schedule this for a Monday morning for the model to show the correct week.

     

    My bad..! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous 
    So everything works fine now?

     


    Paul Zheng _ Community Support Team