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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.