Forum Discussion
Last 4 Week filter
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.
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.
I need the same exactly what you shown , but without using tabular editor.
Is this possible?
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.
Hi,
Format is not a problem , but i need filter to be apply.
Possible?
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.