Top Weeks in graph

[eduardosilvin3]

Hello I am working with weeks, and I need that graph per week (Week Year for Grapgh in X axis) always shows the top 5 weeks (selected plus 4 previous weeks). If it is possible, when any filter is added or selected, shows the top 5 of the whole data (in that case of the example shows the first 5 weeks of that last year. (I covered the data in the graph due to privacy)

[lbendlin]

Hello I am working with weeks

Very sorry to hear that 🙂 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[eduardosilvin3]

Thank you for yoru response, sure here it is the sample data with the graph in the "PBI Help" file. I need that instead it shows all the weeks (the graph), only takes the selected week + the last 4 complete weeks... and if you select another week or several, the last one will be taken as that last one in the graph and shows the last 4 weeks before the selection in the weeks slicer.

 https://onedrive.live.com/?authkey=%21AG9u4wA9u0Qo4FM&id=324EF1095BD7B800%2111236&cid=324EF1095BD7B8... 

[lbendlin · Accepted solution]

See attached for one possible approach with disconnected tables.

Careful with CalendarAuto() - better to use fixed time ranges.