Show data for last 8 quarters on line chart from a quarter value selected

[ManojMunjeti]

I am working on a dax function where the requirement is
Requirement: I select a quarter value from slicer and my line chart shows data for the last 8 quarters.

Additional requirement: If there is no data for a specific quarter the data should show 0 on the line chart

My work: I did create another calendar table called previous dates and here is my dax.

Total Risk Events Past 24 Months =

var ReferenceDate = MAX(Dates[Date])

var PreviousDates =

DATESINPERIOD(

'Previous Date'[Date],

ReferenceDate,

-24,

MONTH)

var Result =

CALCULATE((DISTINCTCOUNT('Risk Events'[Event ID])),

REMOVEFILTERS(Dates),

KEEPFILTERS(PreviousDates),

USERELATIONSHIP(Dates[Date],'Previous Date'[Date])

)

Return

Result

and I do get the result I want except that the quarter where there is no value assigned gets skipped from the axis.

Where there is data for all 8 quarters:

Where there is no data for all 8 quarters from a selected quarter:

Despite no values for all 8 quarters, I want the values to all show up on the chart and show as 0.
Your ideas on this is much appreciated.

[amitchandak · Accepted solution]

@ManojMunjeti , if you select one qtr and what to show more than that you need an independent date table in the slicer

example

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -24) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

refer

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI