Forum Discussion
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 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 .
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.
9 Replies
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=pnAesWxYgJ8In some case, you might need an independent date table, I discussed in this video :https://www.youtube.com/watch?v=44fGGmg9fHI
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.
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.
