Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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?
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?
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,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |