need to shows last 5 week end dates

[mohittimpus]

Hello,

I need a help, I want to show the recent last 5-week end dates and totals along with values from two different tables,  When the select a particular weekend date in the filter

like this  : if select 18 April 2021 In filter

then : 

Date	Values	Values
18-04-2021	326.49	30.44
11-04-2021	454.35	30.75
04-04-2021	414.43	43.32
28-03-2021	402.35	46.93
21-03-2021	273.61	32.36
Last 5 Weeks	1871.23	183.8

Please refer attached recent5Weeks.pbix file : Click here

Thank you 

[Jihwan_Kim · Accepted solution]

Hi, @mohittimpus 

I am not sure how your whole data model looks like, but in my opinion, if you want to select only one date (or one week) from a slicer, and the visualization is needed to show five weeks, a separate slicer table has to be created.

Please check the below picture and the sample pbix file's link down below.

All measures are in the sample pbix file.

https://www.dropbox.com/s/2695v3h28278mkk/recent5Weeks.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, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/