Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello
My doubt is that I am bringing some data like these:
And in the power query editor I wanted to know if it is possible to transform them like this:
It is very easy to do it in a PivotTable but I need to bring it to the PowerBi tables in this format
Thank you!
Jose
Solved! Go to Solution.
Hi @Anonymous ,
You can pivot the column in the Power Query Editor.
Here's the solution.
1.Select the MES column and then click 'Pivot Column'.
2.Set up as follows, then click OK.
3.Here's the results.
Your question was about Power Query and I moved the post to the Power Query forum for you. Next time if you encounter a problem in Power Query, posting in the correct forum can help you solve it faster.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Fantastic, it was exactly what I needed. Thank you!
Hi @Anonymous ,
You can pivot the column in the Power Query Editor.
Here's the solution.
1.Select the MES column and then click 'Pivot Column'.
2.Set up as follows, then click OK.
3.Here's the results.
Your question was about Power Query and I moved the post to the Power Query forum for you. Next time if you encounter a problem in Power Query, posting in the correct forum can help you solve it faster.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Fantastic, it was exactly what I needed. Thank you!
@Syndicate_Admin , Looking at what you posted, not able to get logic. I would not advice data to be broken like that.
use Matrix visual
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Or refer this way
Power bi Excel for P&L , add in app
Curbal
https://www.youtube.com/watch?v=IISYzTaIyu4
Guyinacube
https://www.youtube.com/watch?v=1yJnmZRTNZg
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
41 | |
23 | |
21 | |
20 | |
13 |
User | Count |
---|---|
67 | |
57 | |
48 | |
28 | |
20 |