cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
quinla01
Frequent Visitor

Is there a way to Select All fields in table to add to visual rather than select each one?

Hi, 

Within the Fileds Pane, is there a quick way to select all fields in a table to add them to a visual? My table has about 100 fields and i want to add them all to a table visual. I'm currently selecting each field one at a time. I figure there has to be a quicker way like a right click, select all. 

 

Thanks

 

 

fileds.JPG

 

 

2 ACCEPTED SOLUTIONS
MFelix
Super User
Super User

Hi @quinla01 ,

 

There is no other way of placing the data into a visual only a field at a time.

 

In your case what is the purpose of adding them all to a table visual? If you want to filter the information for the entire table the best way is trough the Data view that allows you to sort, filter copy, hide, etc.

 

Regards,

Mfelix


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

Thanks for confirming. Strange they have thought to add a "select all" option. Seems fairly basic. 

 

The purpose is for reference rather than filtering. Most the data is summarised in other meaninful, smaller visuals but every now and then someone will want to see absolutely every field. 

 

Thanks again.

 

 

View solution in original post

7 REPLIES 7
lauralee
New Member

Hi!

I marked this topic as NEW because it has been a few years since the question was posed and am hoping the has there been added functionality to add all fields to a visual.

Any chance this has been done?

 

Like quinla01 , I have users who want to see the flat data at times.

Hi @lauralee ,

 

There is still no way to select more than one field to add to your visualizations.


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Thank you for your quick response!  Much appreciated.

Unfortunate PBI has not added that functionality as yet.

 

MFelix
Super User
Super User

Hi @quinla01 ,

 

There is no other way of placing the data into a visual only a field at a time.

 

In your case what is the purpose of adding them all to a table visual? If you want to filter the information for the entire table the best way is trough the Data view that allows you to sort, filter copy, hide, etc.

 

Regards,

Mfelix


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Thanks for confirming. Strange they have thought to add a "select all" option. Seems fairly basic. 

 

The purpose is for reference rather than filtering. Most the data is summarised in other meaninful, smaller visuals but every now and then someone will want to see absolutely every field. 

 

Thanks again.

 

 

Adding to this thread and marking as New because there's another use case where this would be helpful - if you are using a dataflow as the source for the PBI data, you can't (at least in my case) go to Power Query or see the Data view. It would be very helpful to be able to create a visual with all table fields so that I can more easily see, e.g., what types of data are in each field. 

 

I still don't see a way to do this, but hoping that I've missed something since this thread was last updated...

 

Thanks!

 

David

Hi @dchilder ,

 

When you refer to Dataflow, Dataset of Live Connection you cannot use the query editor since the datasource are not editable so the query editor is not available, regarding the question about the type of data you can see it by selecting a field and seing the column type and format, has you can see the value is grey out but it's because you cannot edit.

 

MFelix_0-1664526054353.png

 


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.