export table to excel

[Anonymous]

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!

[RobThrive · Accepted 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.