The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi All
I need to export below table to excel :-
After export i get below :-
Can some one advise me how to make above table same as PBI table ?
Below is my PBI file :-
Solved! Go to Solution.
Hi @Paulyeo11
1. Export the data from the visual - this is a CSV
2. Open the CSV in Excel
3. Create a table from the data
4. Insert a pivot table using the table as the source
5. Put Customer/Vendor name in Rows.
6. Put AGING in Columns
7. Put A/R amount in Values (this will automatically SUM values by default)
8. Done.
The amount of data exported from the visual is very small but the process is the same if you had 100,000 rows of data.
Phil
Proud to be a Super User!
Hi @Paulyeo11
1. Export the data from the visual - this is a CSV
2. Open the CSV in Excel
3. Create a table from the data
4. Insert a pivot table using the table as the source
5. Put Customer/Vendor name in Rows.
6. Put AGING in Columns
7. Put A/R amount in Values (this will automatically SUM values by default)
8. Done.
The amount of data exported from the visual is very small but the process is the same if you had 100,000 rows of data.
Phil
Proud to be a Super User!
Hi Phil
Thank you very much for your effort. Excel is very user friendly.
Paul
HI @Paulyeo11
Here's the Excel workbook
The pivot table is on the sheet named paulyeo11
regards
Phil
Proud to be a Super User!
Hi Phil
Can you pls share with me how you create the excel ?
That is what i am looking for.
Paul
@Paulyeo11
You need to create a pivot table in Excel to get the same layout.
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi All
Thank you very much for all your sharing .
can some one share with me how to covert the 3 column excel To 4 column excel pls.
Paul
Hi @Paulyeo11
The data that creates your matrix is from 3 columns, that's what you get when you export the data. The matrix just displays it in this way in PBI. You can create a pivot table in Excel to replicate the matrix visual.
Phil
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |