See Records \ Underlying data

Question

Hi All,&nbsp;Is there a way to show see records \ underlying data columns in alphabetical&nbsp;order for visual?Now PowerBI is showing&nbsp;random order.&nbsp;1. How to arrange columns in see records \ underlying data are alphabetical&nbsp;order in visual?2. How to arrange column are&nbsp;customized order in visual?&nbsp;&nbsp;I don't want to arrange all data in to table visual, then export it.&nbsp;ByGnanasekar

ulrickt · Answer

It is correct that after selecting "See Records" you can click the X in the Visualizations or uncheck the checkbox under Fields. The problem is that as soon as you "go back to report" and open "See Records" again, ALL fields are selected/shown again.

So far I have not been able to find a way to "save" the list of columns i want to have shown each time i click "See Records".

And yes, sadly there isnt any sort function available.

v-qiuyu-msft · Answer

Hi Gnanasekar,
&nbsp;
Power BI will not sort columns automatically, after you enter the See Records view, you can order the columns manually by drag columns in Values pane.
&nbsp;

&nbsp;
Best Regards,Qiuyun Yu

vanessafvg · Answer

Gnanasekar&nbsp;its probably more useful if you explain exactly what you want to do and what is not working for you?

gnanasekar · Answer

Hi&nbsp;vanessafvg&nbsp;Is there a way to show see records (or) underlying data columns in alphabetical&nbsp;order based on columns name in visual?Now PowerBI is showing&nbsp;random order.&nbsp;Example: Dataset columns name are 'A,B,C,D,E,F,G'. (6 columns)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; In visual see records option&nbsp;(or) export underlying data I can able to see all (6 columns) in PowerBI.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; But PowerBI was showing in random order like (E,G,B,A,F,C).&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; It was not&nbsp;in alphabetical order of columns name and not in dataset order also.&nbsp;&nbsp;1. How can I arrange columns in see records \ underlying data are alphabetical&nbsp;order in visual? [order like: A,B,C,D,E,F,G]2. How can I arrange column are&nbsp;customized order in visual? [order like B,C,D,A,G,F (customize by developer)]&nbsp;&nbsp;I need not&nbsp;table, matrix visuals. So Please give solution based on remaining visual&nbsp;ByGnanasekar

Forum Discussion

See Records \ Underlying data

4 Replies

Related content

Underlying Error Privacy...combining of data

Underlying Error: OnPremiseServiceException

Export underlying data

Underlying ErrorOnPremiseServiceException

Summarized Data vs Underlying Data