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. Can someone please help me with this one.
I have a table for all the expensenes monthly sliced. I need to have 1 column and have all the months as a selection so which ever I select it should show that months figures.
Please can someone look and advise if that is possible
Solved! Go to Solution.
@ahsanlhcgov select your period columns and unpivote them. Then you have exactly what you want.
Regards.
Pavel
You need to unpivot your data during the get data process.
Here is an old video I created. The principle and approach is the same in Power bi
You need to unpivot your data during the get data process.
Here is an old video I created. The principle and approach is the same in Power bi
@ahsanlhcgov select your period columns and unpivote them. Then you have exactly what you want.
Regards.
Pavel
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |