Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
https://m.youtube.com/watch?v=K7VS5oqjCxU
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
https://m.youtube.com/watch?v=K7VS5oqjCxU
@ahsanlhcgov select your period columns and unpivote them. Then you have exactly what you want.
Regards.
Pavel
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
100 | |
65 | |
44 | |
36 | |
36 |