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
Could someone please solve this?
This needs to be transformed in Table View (or any other visual):
a b
1 1
into:
a 1
b 1
Many thanks
David
Solved! Go to Solution.
Hi @magyar,
In your scenario, you can transform the data in Query Editor. Please select those two columns, then click Unpivot Columns.
Then apply the change, drag the column Attribute and Value to the table visual. You can download attached .pbix file to have a look.
Best Regards,
QiuyunYu
Hi @magyar,
In your scenario, you can transform the data in Query Editor. Please select those two columns, then click Unpivot Columns.
Then apply the change, drag the column Attribute and Value to the table visual. You can download attached .pbix file to have a look.
Best Regards,
QiuyunYu
Brilliant!
Thanks a lot QiuyunYu for taking the time to answer my question, really appreciated.
David
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |