How to Arrange the columns in the "Show data as table" section for Matrix

[sepehr485]

Hello All

I have a matrix  and when I right click on a cell in the matrix, I have an option to choose "Show data as table".

I want to know how I can organize the columns shown on that table and save it ?

Thanks

[lbendlin]

that depends on how you organized the columns in the actual matrix visual.

Once you save the layout, what do you want to do next?

[sepehr485]

Hello there.

I want to save the layout so that when folks see the data as table, they can see the priority columns first. currently every time I arrange it through the visual panel . It doesnt save and everyime I click to shoe the data as table I see it not arranged the way I want. Can you please show me where do you mean by orginal matrix visual? Thanks

[Anonymous · Accepted solution]

Hi @sepehr485 ,

As far as I know, "Show data as table" is just a function for us to learn data clearly. Power BI doesn't support us to save data in this function or do some interaction in that table. I suggest you to create a table visual or create a calcualted table as you want. Or you can try to export data from matrix visual.

For reference: Export data from a Power BI visualization - Power BI | Microsoft Docs

Best Regards,
Rico Zhou

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