I have a spreadsheet with projects that have budgets over multiple years.Example:Project Name2022202320242025Project 110,00015,00010,000 Project 225,000 15,00010,000How 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!

Anonymous , you can unpivot the columns in Power Query editor, then year as a slicer, Thanks,

How to create slicer/button for different years?

Arul
Super User
3 years ago
Anonymous , you can unpivot the columns in Power Query editor,

then year as a slicer,

Thanks,
Anonymous
Not applicable
3 years ago
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
  Super User
  3 years ago
  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,
  - Anonymous
    Not applicable
    3 years ago
    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.
Anonymous
Not applicable
3 years ago
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?