Slicer Filter Interaction With Chart

veryconfused - You want The Complex Selector. The example solved is almost exactly your scenario:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

Also, since I see you are a New Member, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Hi veryconfused,

You will need a disconnected Week Dimension that you can use as the X Axis for your Chart. Then you would create a measure like the one below: 

Dynamic X axis = 
    var selectedWeek = max('calendar'[Week])
    var floorWeek = max('calendar'[Week])-6
return
    if
        (
            HASONEVALUE('Calendar dynamic'[Week]) && VALUES('Calendar dynamic'[Week]) >=floorWeek && VALUES('Calendar dynamic'[Week]) <= selectedWeek, 
            CALCULATE(SUM(FTE[FTE]), 'Calendar'[Week] = VALUES('Calendar dynamic'[Week]))
            ,BLANK()
        )

Essentially you are assigning a value where the disconnected week is between the floor and ceiling weeks, otherwise Blank() is returned, leaving you with a chart that looks something like

Hope this Helps,
Richard
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Thanks to all for posting replies, and links to forums resources. I have been working on this for hours and can't quite figure the solution..

Greg_Deckler  and richbenmintz :

I have tried both of these solutions with the same outcome.

• Created a disconnected dates table for both solutions, with a single column of the date.
• The slicer is using the date from my sales table, not the disconnected date - tried using the disconnected date for the slicer and got no results
• In both cases, the chart now shows the desired weeks back on the x axis
• However, the value measure I'm trying to calculate (sum of sales) shows the total for all 3 weeks in each week, rather than each week's total.
  • I feel like this must have something to do with using the disconnected date table and I can't quite understand how to square it.
  • To note, in either case I'm calling a measure I created earlier that's simply SUM(Net Sales). I also tried to write it SUMX(SalesTable, Net Sales) to no change.

Any ideas on what I'm missing here greatly appreciated.

Hi richbenmintz 

Had to whip up some dummy data. Posted at the link below. Thanks again.

(Edit: Below link updated w/ data showing different sales per week.)

https://www.dropbox.com/s/lxfoxejuh43kzmt/DummyReportSlicers.pbix?dl=0 

Hi,

See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.