Creating Data Tables and Lookup Tables
Relationships are essential for connecting data tables and lookup tables, allowing you to link transactional data with its corresponding contextual information. In Power BI, you can create relationships by dragging and dropping fields between tables.
- Get data from the main “Home” screen.
2. Choose the type of data source and location of your data. In the above image, the chosen data type is excel sheet, it can be any thing as per the user’s need.
3. After choosing the data source, the user can see the data table in the Power BI desktop.
3. Create new table from the “Modeling” tab in the top.
4. You can format the table by adding new columns , editing columns. Select the “Visualizations” pane, and then drag and drop the formated columns as per the requirement of visualization with appropriate fields. The user can customize the visualization by adjusting settings like colors, and data labels and others.
You can also add conditional columns also.
Other conditional formating includes sorting (both ascending and descending order), filtering which apply filters to your data table, grouping and aggregating your data using “Group By” functions from “Modelling” tab.Even the DAX functions can be used to enhance your already existing data.
5. Format the look and feel of tables.
Play around with other features with needed requirements.
6. Power BI also provides the power query editor which helps in manipulating and changing your data. You can add new columns, modify existing ones and save them so that the changes are applied on your datatables.
7. Share your data table in the desktop. This feature helps in publishing your report to the Power BI service.
Understanding Data Tables vs. Lookup Tables
Power BI Data Tables are like normal tables like Sales data tables with sales-related columns or information fields. It can have numeric values and quantitative values like total sales, loans taken, salary, and so on. They are also known as fact tables.
In this article, we will learn the basics of data tables further knowing their importance and basic features. It will also help in understanding the difference between Data Tables and Lookup Tables. The article will take you to the process of creating, importing, and managing data. Finally, we’ll show you how to customize and visualize data tables with others.