Forum Discussion
How do I visualize this table?
The data structure is obviously incorrect for what you're trying to do. Use Power Query to unpivot the data so that all years are in one column (this is a one-click operation). Then and only then will you be able to easily do what you want. Do not work against Power BI's philosophy unless you want to suffer a lot. Work in harmony with its principles and you'll reap the fruit in no time (and things will be easy and fast). Please read this to always model data correctly.
The data structure is obviously incorrect for what you're trying to do. Use Power Query to unpivot the data so that all years are in one column (this is a one-click operation). Then and only then will you be able to easily do what you want. Do not work against Power BI's philosophy unless you want to suffer a lot. Work in harmony with its principles and you'll reap the fruit in no time (and things will be easy and fast). Please read this to always model data correctly.
Thank you for the quick help. I really need to look into that. Much appreciated!