Date is not changing in service but changing in desktop

[Omega]

Hi all,

I am trying to current dates into certain weeks that I have defined. I have created the mapping of date to week. In my desktop, I can see that the weeks are changing but when I publish the report in service, the week is stuck and doesn't change. 

I have created a measure called date and used Today () function. 

Please advise. 

Thanks!

[v-yulgu-msft]

Hi @Omega,

What do you mean "I am trying to current dates into certain weeks that I have defined. I have created the mapping of date to week. "? Could you provide more details about how you created the report, and how you mapped Today() with week so that I can test in my environment?

Did the week value refresh on service if you clicked the refresh button manually? Did issue persist after you remove and re-publish the report to service?

Best regards,

Yuliana Gu

[Omega]

hi,

I have two tables, one that contains the data (sales, date....etc.) and I the others contains dates and their corresponding weeks. I created a relationship between these tables using date. 

In my report, I created a measure called current date and used Today () function and I created another measure called current week and used Related function to get the week based on the current date. 

On my Power BI desktop, I can see that the weeks gets changed which is correct but on Power BI Service, it doesn't change and remain as is. I tried to refresh the reports on Power BI Service but the week remains as is. 

I hope this explain the challenge better. 

[v-yulgu-msft]

Hi @Omega,

Not sure how you created the two measures.

Please try this:

Current date=Today()

Current week = WEEKNUM([current date])

Best regards,
Yuliana Gu

[Omega]

My definition of week is from Wednesday to Tuesday and not Monday to Sunday and that's why I created a seperate table for week defintion. 

Out of curiousisty, I tried weenum and set the function to show the week number based on ISO weeks, weeknum (today(), 21). When I checked the week in Power BI service, it shows 39 where it should be 38. Please note that the date is 24th of SEP. 

Thanks!

[Greg_Deckler]

Is this in a dashboard? When you pin a tile to a dashboard it retains the filtering that it had at the time of pinning.

[Omega]

Hi, 

This is on the report and not dashboard.

Thanks!