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 all,
I am new to Power BI and migrating the report or dashboard from legacy tool to power bi. We have the requirement as follow
1. On Legacy tool - Grid Report in Dashboard with have the page by option
2. Export to PFD - Will slice the data using page by option as each session
How to achieve this in power bi
EX:
Category - Product - Sales - Revenue - %
Cat1 - Prod 1 - 100 - 100 - 2%
Cat1 - Prod2 - 100 - 100 - 1%
Cat2 - Prod1 - 100 - 100 - 1%
Expecting Output: Export to PDF / Excel
Cat 1 with product details as page / sheet
Cat 2 wiith product details as new page / new sheet
Please suggest
hi, @jovitasaishri
After my research, I'm afraid it couldn't achieve in Power BI for now.
Export to PDF is only available with Power BI Desktop, and is not currently available in the Power BI service. and it will export the whole report to PDF. and it will affect by the slicer or hide page.
https://docs.microsoft.com/en-us/power-bi/desktop-export-to-pdf
Export to Excel can export that data to Excel as an .xlsx or .csv file.
when you select Underlying data > Export and choosing .xlsx. It will export the detail data, and it is only in the same page,
not one category per page.
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-export-data
For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .
Best Regards,
Lin
Best Regards,
Lin
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |