Display latest 10 week data in pivot table

[Anonymous]

Hi I have a table with Product as Row, Units Sold as Value and Calendar Month as Column as in the attachment

I want to create a Matrix chart as above. 

1. Calendar Week as Column should be sorted in descending order.

2. Calendar Week is populated from the source itself with year and week number together. Every time I open my Dashboard I want to see the lastest 10 weeks data based on the refresh date. 

Note: I mentioned by mistake the column as Calendar Month in the image attached.. it should be Calendar Week.

Example as above: Consider we are in 201810 th week.

When I refresh my dashboard the next week ie. 201811 then I should see the chart as below

3. If I select from Slicer any week then the above chart should display the last 10 weeks data.

For example: If I select 201740 from slicer. Then my Matrix chart should display the corresponding data

Can someone help me on this please?

[Greg_Deckler]

Well, you could create a table with a single row and a column that is basically:

Column = TODAY()

This will get set to the latest refresh time. You should then be able to use this to do a filter on your matrix. But, without sample data, etc. would be difficult to be more specific.

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Thanks for your Suggestion Greg, as you see I have shared an example of what I am actually looking for in the attached Photos.  As I am just learning Power BI. I don't have an organized data source or .pbix to share with you. In the photo attached I have mentioned Calendar Month which should be Calendar Week. Sorry about that 😞  

[Greg_Deckler]

The issue is that you are showing the result of what you want, which is great, but not what the source data looks like, even if you just mock it up. Makes a big difference in the actual correct solution.