I want to project monthwise data in matrix table using raw data. For example I have 12 rows which displays the salary of one individual employee from april to march. Now I want to display and convert 12 rows in a single row and make month's name as columns name.
Can someone tell me, Is it possible to project such data in Power BI report??.