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.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

I will create a sample pbix file by using my sample.

At this moment, I think I need to transform my original sample data to be unpivoted.

But, I am not sure how your table looks like.

 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for your solution.

    Got it!