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 questions is can I fill the blank data using data from Excel file?

 

Regards,

 

Amirul.

Need Help
Show and Tell
Tutorial Requests

1 Reply

  • 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.