cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

See Records \ Underlying data

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

4 REPLIES 4
Highlighted
Super User I
Super User I

Re: See Records \ Underlying data

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper III
Helper III

Re: See Records \ Underlying data

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

Highlighted
Community Support
Community Support

Re: See Records \ Underlying data

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.

 

q1.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: See Records \ Underlying data

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.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors