Last 4 Week filter

[Anonymous]

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 and prior to that upto 4 .

Note-

I tried using relative function , but its not came for me.

Because , the data which i have is last year data. And if i use Relative function of last 4 week it considering present date and showing blank value.

I need solution to be like below,

Please help .

[Jihwan_Kim]

Hi, @Anonymous 

Please check the below picture and the sample pbix file (link down below), whether it is what you are looking for.

I used Tabular editor in Power BI to create two calculation groups

1 calculation group = the purpose is to differentiate the number format (currency, non-currency)

2 calculation group = the purpose is to present the current week and the rest of the 4 previous weeks each.

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]

I need the same exactly what you shown , but without using tabular editor.

Is this possible?

[Jihwan_Kim]

Hi, @Anonymous 

Thank you for your feedback.

it is still possible, I think....

but I don't think I can still display different number format (dollar and non-dollar) in one visualization.

[Anonymous]

Hi,

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

Possible?

[Jihwan_Kim]

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.

[Jihwan_Kim]

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 · Accepted solution]

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]

Thanks for your solution.

Got it!

[amitchandak]

@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