Show Past 7 quarters in the line chart even if the user select single quarter in the slicer

[SaiSaranya1095]

Hi ,

Can anyone please help me in solving this!!!!

• I have a calendar table and fact table. In the line chart with Year qtr Field in the axis,7 fields in the values Field well in line chart And date  slicer is a hierarchy. So even if the user selects one qtr the line chart Must show the data from past 7 quarters. Please help me in this.
•  
• Thank you 

   

  

[SaiSaranya1095]

The above mentioned is the sample Data.

user selects a value from the Date hierarchy slicer from the Dimcalendar 'Date 'Slicer .

Line chart 

Axis - YearQtr (from Dim Calendar)

legend - Sub-Region(from Dim country)

Values - 90days,180days,D360days,D720days (From Fact Table)

Line chart must show  data past 7 qaurters even if the user selects single quarter from the Date Slicer.

i.e if user selects 2021  Qtr 4 from Date Slicer, line chart must show Data from 2020Q2 to 2021Q4 with respective values. 

[Greg_Deckler]

@SaiSaranya1095 You will need a measure that uses ALL and then filters back down to the correct values. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, 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.

[SaiSaranya1095]

Region	Country	Date	90days	180days	360days	720 days	>720 days
Asia	China	sunday,1 December 2019	100	200	300	400	500
Asia	HongKong	sunday,1 December 2019	200	300	400	500	600
Asia	China	Monday,1 june 2020	900	200	300	400	500
Asia	HongKong	Monday,1 june 2020	100	300	400	500	600
(DimCalendar)
Date	Year	Quarter	Month	Day	Year Qtr	Yearmonth
Tuesday,31 December 2019	2019	Q4	Dec	31	2019Q4	2019.12
Monday,30 December 2019	2019	Q4	Dec	30	2019Q4	2019.12
(Dim country)
Region	Sub region	Country
AP	china	china
AP	china	Hongkong