DAX for showing SIX months data based on date selected in Visual

[venkatnitt84]

Hi - I have to show six months trend based on selected Month and metric in Matrix Visualization.

For Example if April 2019 and metric 4 is selected for given Student in the matrix visual ,  graph with previous 6 months trend ( Nov 2018 , Dec 2018 , Jan 2019 , feb 2019, march 2019,april 2019) for 2 measures (Say measaure 1 and Measure 2) should be shown. below is the data model. and expected Visualization. Is it possible ?

i tried with dax , but as soon as i selected . It filters out the data. Even if i ignore it in the DAX using ALL and other functions it doesnt work as expected Visual

VisualTrendDataModel

[v-cherch-msft · Accepted solution]

Hi @venkatnitt84 

You may have a look at this article.Attached the sample file for your reference.

Regards