Home Tab in Query Editor: "Choose Column" option in home tab of query editor in Power BI: Lesson-7 P-18
The "Choose Column" option in Home tab of query editor: Lesson-7 P-18
The "Choose Column" option isn't directly available on the Home tab of the Power BI Query Editor, but there is a way to access it that makes managing your data easier. Here's how to use it:
Go to the Query Editor: If you're not already in the Query Editor, you can access it by going to the "Transform Data" option on the Home tab in Power BI Desktop.
Find the "Select Columns" option: Within the Query Editor, find the "Manage Columns" group on the Home tab. There, you will find the "Select Column" button.
Using "Choose Columns":
Clicking "Choose Columns" opens a dialog box that lists all the columns in your table. Then you can:
Keep specific columns: Select the check boxes next to the columns you want to keep in your dataset.
Remove Unwanted Columns: Uncheck the boxes of any columns you don't need.
After making your selections, click "OK" to keep only the selected columns in your table.
Additional tips:
An alternative way to remove columns is to select them and right-click on any column header. A context menu will appear with a "Remove Column" option.
For more advanced management of your data, the "Transform" tab in the Query Editor offers additional options for shaping and transforming your data.
By using "Select Columns" you can efficiently select specific columns relevant to your analysis in Power BI.
Lab Work of Choose Column:
Choose Column Menu
1:- Choose Columns
- Delete unselected columns
- Home --> Choose Columns --> Choose Column
- chose 1st name column & Fee column
- Home --> Choose Columns --> Choose Column
After click on OK
you have only selected column and other all remove.
then you have
2:- Go to Column
- Home --> Choose Column --> Goto Column
- Select heading(colum)
- Click OK
- then you will reach required column
Thanks
Tags:
- Power BI
- Query Editor
- Choose Column
- Data Transformation
- Data Analysis
- Data Visualization
- Data Management
- Data Cleansing
- Data Preparation
- Column Selection
- Dataset Management
- Streamlining Data
- Data Filtering
- Data Manipulation
- Data Exploration
- Data Optimization
- Data Efficiency
- Large Datasets
- Column Filtering
- Simplified Analysis
- Improved Performance
- Relevant Data
- Business Intelligence
- Power Query
- Power
- Microsoft Power
- BI
- Microsoft
- Go
- Go to
- Goto Column
- Goto
Related Posts
Leave a Reply
You need to login to write a comment!
Popular Posts
-
Khewra Mine Salt
28.12.2023 0 Comments -
Magic Spoon Cereal Review
28.10.2023 0 Comments -
Gus's Fried Chicken
27.12.2023 0 Comments -
free software download websites for pc
21.09.2023 0 Comments -
Perfume History: Perfume: Cologne: Scent: Fragrance
02.04.2024 0 Comments -
Egyptian Perfumery: Perfume History in Egypt
03.04.2024 0 Comments
Categories
- AUTO(11)
- HEALTH(94)
- TECH(10)
- SCIENCE(0)
- SOCIAL MEDIA (0)
- PRESS RELEASES(0)
- TESTIMONIALS (References)(6)
- BIO(1)
- SPORTS (9)
- EARNING ONLINE(0)
- ARCHITECTURE(1)
- IT(51)
- Accessories(3)
- News(19)
- Pet(13)
- Programming (5)
- Shopping (15)
- Visiting Place (18)
- Foods & Candies(9)
- Style and Fashion (3)
- Geography (1)
- Personalities(2)