Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
hi all
I have a problem with data editing, as shown in the first picture below, which is my basic data
I want to convert it to this picture
In the second image I turned the location column into a row and filled in the values for the next three fields
Can this be solved by M function? If so, thank you very much
Best Regards
alan-li
Solved! Go to Solution.
Hi @Anonymous ,
Based on your basic data, we can achieve your desired output using Matrix Table
If I am not mistaken, M Query cannot have sub column like you wanted on the second column.
Hi @Anonymous ,
Based on your basic data, we can achieve your desired output using Matrix Table
If I am not mistaken, M Query cannot have sub column like you wanted on the second column.
Good to know you have solved the problem
hi @mussaenda
I would like to know if I can export the data according to the template of my table
I haven't found the relevant information, please let me know if you know thinks
Best Regards
alan-li
Hi @Anonymous ,
You cannot.
There is a workaround but it needs time and effort.
If you really wanted to export the matrix style, save first the page in pdf then convert pdf to excel.
hi @mussaenda
Why is mine displayed like this
Is there something else I need to set up, I just found the drill data
Best Regards
alan-li
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
80 | |
79 | |
59 | |
36 | |
35 |
User | Count |
---|---|
99 | |
57 | |
56 | |
46 | |
40 |