Relative date slicer - calendar week from Mon to Sun

[karo]

Hi,

Is there any way to use Slicer- Relative Date for last 2 calendar weeks, but from Monday to Sunday (in Live connection mode)? 

Regards,

Karo

[karo]

@v-rzhou-msft It is really sad that it is still not implemented. Hopefully idea with more than 1,3K votes will be "under review" soon. 

[karo]

@v-rzhou-msft , @amitchandak  thanks for replies. 

I will vote on idea (https://ideas.powerbi.com/ideas/idea/?ideaid=c0261391-c1c1-4452-ac59-2cf8c6a09983&page=17), because, from my perspective, currently Slicer- > Relative Date - > Weeks (Calendar) is useless in Europe and even can be misleading for report users. 

Regards,

Karo

[v-rzhou-msft · Accepted solution]

Hi @karo 

Your problem is that you want to show the week starts from Mon to Sun instead of Sun to Sat in relative date in slicer.

I found a post with the same problem like yours: Date slicer - relative weeks showing Sunday to Saturday weeks. 

Vote an idea in Power BI Idea will help.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Could you kindly accept the helpful reply as a solution? 

More people who have the same requirement will see this post and vote for your idea.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[v-rzhou-msft]

Hi @karo 

You need to build an Accumulate Weeknum, due to weeknum function will begain from 1 again in a new year.

You can't build calculated column if your connection mode is live connection.

If you try import connection, you can try the way like this post: Display last 6 week data for Year change

Just display last 2 week data for year change by above post.

Build a slicer by [Date] column ,add last 2 week column into filter field in slicer and set it to show items when value =1.

If you still need to get data by live connection mode, build Accumulate Weeknum in your underlying data source and build a measure to show last 2 weeks. Add this measure to show items when value=1 as a filter in slicer.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak]

@karo , on of the way is have date table at the source having the week from Monday to Sunday.