Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Last 4 Week filter

Hi ,   Any one please help here,   I need last 4 week to filter automatically in chart , see the below content for example.   I need individual filter to all visuals based on last week an...
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous  please check the link down below.

    Please check page2, which is shown without using a tabular editor in Power BI.

    In this case, I created one more table that is for the WEEK-Variance-Non-Tabular-Editor-Table.

     

    https://www.dropbox.com/s/9dd1yerghfz9rpm/mogunase1.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , refer to my week on week blog if this can help you

 

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

 

 

In some case, you might need an independent date table, I discussed in this video :https://www.youtube.com/watch?v=44fGGmg9fHI