Forum Discussion

AmirulAzim's avatar
AmirulAzim
Regular Visitor
3 years ago

How to fill in blank data using another source.

Hi everyone. I just started using Power BI and have created a dashboard. The data I use is from Sharepoint List. After I created the dashboard, I found out there are missing values in my data. My que...
Need Help
Show and Tell
Tutorial Requests
mohdasaad94's avatar
mohdasaad94
Helper I
3 years ago

Yes, you can fill in blank data in Power BI using data from an Excel file. Here are the steps to do this:

  1. Import the Excel file data into Power BI: Go to Home > Get Data > Excel, and then select the Excel file you want to use. Follow the prompts to import the data into Power BI.

  2. Create a new table in Power BI: Go to Modeling > New Table, and then create a new table that contains the missing data. For example, if you have missing values in a "Sales" column, create a new table that has the same column name and contains the missing values.

  3. Merge the new table with the existing data: Go to Modeling > New Column, and then select "Merge Queries" from the drop-down menu. Choose the existing table and the new table you created, and then select the column you want to merge on. This will create a new table that combines the missing data with the existing data.

  4. Replace the existing data with the new merged data: Go to Home > Edit Queries, and then select the merged table. From the drop-down menu, select "Replace Current" to replace the existing data with the new merged data.

  5. Refresh the data: Go to Home > Refresh, and then refresh the data to see the changes.

Once you have completed these steps, the missing data should be filled in with the data from the Excel file.