cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Imagauthamam
New Member

How to move certain columns to the right when using export to excel option in power bi service

I have a matrix visual in power bi service. The values in the matrix visual are created using a measure. The measure calculation involves date dimension table and a fact table.

 

So when I use export to excel option in power bi, i get columns from both date table and fact table as well.

 

I know that we can't hide the columns once it is used in the column. But is there any option to move date dimension columns to the right?

 

1 ACCEPTED SOLUTION
v-jianboli-msft
Community Support
Community Support

Hi @Imagauthamam ,

 

As far as I know, you cannot move a column to the right with Power BI's export to data feature.

If you want to make changes to the layout of the exported data, you can only do so by editing the file itself.

 

If you also want this in  Power BI, let the power bi community to know this things and give your votes at  Power BI site's feedback -

Ideas

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-jianboli-msft
Community Support
Community Support

Hi @Imagauthamam ,

 

As far as I know, you cannot move a column to the right with Power BI's export to data feature.

If you want to make changes to the layout of the exported data, you can only do so by editing the file itself.

 

If you also want this in  Power BI, let the power bi community to know this things and give your votes at  Power BI site's feedback -

Ideas

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors