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 II
Super User II

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
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors