Forum Discussion
Solved
Select for Year when each year data represents diff column
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 2...
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
unpivot is great and simple.
Thx