From time to time, you will be asked to build a dashboard with data provided by an end user or client. This post will demonstrate the Power BI Fill Feature, which is one of many useful transformation capabilities available in Power BI Desktop. Specifically, this use case data is filled only at the top row of a data block, and left with null/blank values for the rest. In stead of having to “Fill” these values down for each row in the data source file (Excel), we will use the Power BI Fill Feature to accomplish this task!
Power BI Fill Feature – Step by Step
First, select Get Data and load your respective data source. For this example, I am using a sample Excel dataset:
Notice the blank values in the Tourney and Course columns. Only the very top values have been entered, and were left blank until the next data block started (one data block for each grouping – tourney).
This is where the Power BI Fill Feature comes into play! Make sure you are in the Power Query Editor, and select the Transform tab. Then select the Tourney and Course columns. From the Transform ribbon section, select Fill –> Down.
View the Tourney and Course columns. Each data value (top row) has now been filled down until the next change in data. This save a lot of manual copy and pasting in the source Excel file!
As I continue my journey in learning Power BI, I will continue to add posts as learn new features. Enjoy!