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

[Imagauthamam]

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?

[v-jianboli-msft · Accepted solution]

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.