Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Im having some issues exporting the tables in my dashboard through live connection and that is inside the Power BI Portal(Viewer Mode). I have inside this table different metrics with 3 different timelines which I can drill up or drill down: Fiscal Year, Quarter, Month, Week. When I want to export the table to excel , Power BI automatically exports the whole table with the timelines and when opening the excel file I see many rows with the "weeks" of every month so I have a huge table and also the metrics that where originally showned as rows in my power bi table, in the excel they are showned as columns...
this is how I want the table:
Is there a way to just export the until the month level for example evading the data from the week Level hierarchy?
Thanks!
Solved! Go to Solution.
That is exactly how it works. Gives the user power to do things their own way with the data.
All you need to do is just create a pivot table in Excel now, and it'll match your desired outcome.
That is exactly how it works. Gives the user power to do things their own way with the data.
All you need to do is just create a pivot table in Excel now, and it'll match your desired outcome.