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.
Hi Guys,
I´ve this BI Table. In The column "Time.Years" I´ve the years 2016 - 2019.
Instead of having one column with all years i would like to have seperate columns for every year.
Like in this excel the amount should be shown in the right year column.
I´m sure that can be handled with Power Bi
Thanks for your help!
Solved! Go to Solution.
You can do this in Power Query.
Go to Edit Queries and in the transform section select the column and choose "pivot column".
Best,
Lars
You can do this in Power Query.
Go to Edit Queries and in the transform section select the column and choose "pivot column".
Best,
Lars
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |