See Records \ Underlying data

[Gnanasekar]

Hi All,

Is there a way to show see records \ underlying data columns in alphabetical order for visual?

Now PowerBI is showing random order.

1. How to arrange columns in see records \ underlying data are alphabetical order in visual?

2. How to arrange column are customized order in visual?

I don't want to arrange all data in to table visual, then export it.

By

Gnanasekar

[UlrickT]

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.

[vanessafvg]

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

[Gnanasekar]

Hi @vanessafvg

Is there a way to show see records (or) underlying data columns in alphabetical order based on columns name in visual?

Now PowerBI is showing random order.

Example: Dataset columns name are 'A,B,C,D,E,F,G'. (6 columns)

              In visual see records option (or) export underlying data I can able to see all (6 columns) in PowerBI.

              But PowerBI was showing in random order like (E,G,B,A,F,C). 

              It was not in alphabetical order of columns name and not in dataset order also. 

1. How can I arrange columns in see records \ underlying data are alphabetical order in visual? [order like: A,B,C,D,E,F,G]

2. How can I arrange column are customized order in visual? [order like B,C,D,A,G,F (customize by developer)]

I need not table, matrix visuals. So Please give solution based on remaining visual

By

Gnanasekar

[v-qiuyu-msft]

Hi @Gnanasekar,

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.

Best Regards,
Qiuyun Yu