Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello. I have line chart and a month slicer. I want my line chart to only show 4-months prior to the month selected on the month slicer.
How do I set the filtering on the line chart so that it follow accordingly to the month selected on the month slicer, and show data for only 4-months prior? Thank you.
I have a detailed tutorial on my channel, do check it out.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
One of ways to achieve this is to create a disconnected table for the slicer.
I hope the below can provide some ideas on how to create a solution for your datamodel.
Qty total measure: =
VAR _selectedmonthend =
MAX ( 'Slicer table'[Year-Month sort] )
VAR _fourmonthsperiod =
EOMONTH ( _selectedmonthend, -4 ) + 1
VAR _calendarfilter =
FILTER (
ALL ( 'Calendar' ),
'Calendar'[Date] >= _fourmonthsperiod
&& 'Calendar'[Date] <= _selectedmonthend
)
RETURN
CALCULATE ( SUM ( Sales[Qty] ), KEEPFILTERS ( _calendarfilter ) )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
125 | |
78 | |
76 | |
58 | |
51 |
User | Count |
---|---|
166 | |
84 | |
68 | |
67 | |
57 |