How to create slicer/button for different years?

[cmajewsk]

I have a spreadsheet with projects that have budgets over multiple years.

Example:

Project Name	2022	2023	2024	2025
Project 1	10,000	15,000	10,000
Project 2	25,000		15,000	10,000

How can I create some buttons for the years i.e. 2022, 2023, etc. and when I click on a particular year button it will popultate the table with only the projects that have budget in that specific year?

Thanks for all your help!

[cmajewsk]

Quick question on this. I added a new column to my data source. And when I add info into all the cells of the new column is it missing in the data model for a lot of them. Do I need to un-pivot and repivot with the new column added? How can the data in this new column to show up in all the cells of the data model? 

[cmajewsk]

I see Unpivoted Columns in the Applied Steps, but then what are you doing with the Renamed Columns? What columns are you renaming?? Is it the Attribute Column?

[Arul]

If you unpivot the columns "by default" column names will be
1. Attribute->Year
2. Value->Budget

I just renamed it to provide a meaningful name. So, it is easy for you to identify the column.

Thanks,

[cmajewsk]

Thanks for all your help! I see if add rows into the souce data PBI just takes care of the entries for each year. Again thank you.

[Arul · Accepted solution]

@cmajewsk , you can unpivot the columns in Power Query editor,

then year as a slicer,

Thanks,