Dynamic Filtering on Single Column Based on the Year filter

[ncbshiva]

Hi Team,

I have a Date Table with Year filter and Comparison column from Compare table and i need to show the below structure based on the Year selected.

Comparison	Actual			Target1	Target2	Plan	Plan
Name	2019	2018	2017	2018	2018	2018	2019
A
B
C

For Example : If i select year 2018 , then "Actual" from my Comparison should show all the data available irrespective of the year selected. Then my "Target1","Target2" and "Plan" should show the data for the selected year. And "Plan" should also show the data for next year w.r.t the selected year.

Please let me know how to achieve the above solution in one single matrix.

Regards

SHIVA KUMAR 

[v-juanli-msft]

Hi @ncbshiva 

This may not be achieved by one single matrix, maybe we could try several matrixs/tables and match them to show expected visual.

Best Regards
Maggie

[ncbshiva]

Currently i am using several matrices and combined them to show as single matrix. But this will not work because i have more than 10,000 records , so users need to scroll down , which is not possible to work with three different matrices

Please let me know if this can be achieved by DAX .

Regards

SHIVA KUMAR

[ncbshiva]

Can anyone please help me to achieve this solution ?

Regards

SHIVA KUMAR