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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

Format is not a problem , but i need filter to be apply.

Possible?

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Please check the link down below.

 

You can refer to the Page 3.

Related measures are in the folder name = Page3measures

The used tables in this case are Dim-Date-Table / Main Table / Description Table / Week variance non tabular editor Table -> 2 general tables plus 2 additional tables.

 

Just for your reference, if you use the tabular editor in Power BI, you can just use 2 general tables, and no need to create additional tables.

 

Thank you.

 

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.