Select for Year when each year data represents diff column

[jeyare]

Hi there,

I will be grateful for an idea of how to make a time (Year) filter from the data (Main Table), where the data for the corresponding year is stored in the columns:

Item1	Item2	2015	2016	2017	2018	2019	2020	2021	2022
AAA	AA
BBB	AA
CCC	BB

My target:

1. I created a new "Year Table" with a single column (Year) and appropriate years data there (2015-2022) based on the Main Table columns.

2. I got stuck in creating a relation with the Main Table data (year defined by column), where:

Selection (slicer, measurements, ...) of the Year Table will get the exact Year from the Main Table.

Thx for your help.

J.

[jeyare]

unpivot is great and simple.

Thx

[amitchandak · Accepted solution]

@jeyare , if the table shown above is the source, then unpivot the data

https://radacad.com/pivot-and-unpivot-with-power-bi

]If you want sort desc on the matrix column refer

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c