How to Pivot Power BI Parameters into Columns by Date
Question details
The user needs to pivot a Parameter column by date in Power BI, but the process generates null values because the parameters are grouped separately rather than combining values for the same date.

- Product
- Power BI
- Device & OS
- not provided
- Scenario
- Transforming and pivoting data columns using Power Query.
- Observed behavior
- Pivoting the parameter column produces null values due to improper grouping of the date identifiers.
Ensure you have access to the Power Query Editor and verify that your date column contains uniform date formats without hidden timestamps before applying transformation steps.
Review Pivot Settings and Seek Expert Community Support
Since complex null-producing pivot issues are specific to your dataset's structure, reviewing your Power Query advanced grouping steps and consulting the Power BI Community is the most effective approach.
In Power Query, nulls often appear during a pivot operation when row identifiers (like dates) are mismatched or when the aggregate function is incorrectly configured.
By adjusting the advanced pivot options and verifying your grouping identifiers, you can often resolve the issue. If the problem persists, the official community can provide customized M code.
Before pivoting, click on your Date column and change the data type strictly to 'Date' to remove any time variations that might cause separate groupings.
Select the parameter column, navigate to the Transform tab, and click 'Pivot Column'. In the dialog box, expand 'Advanced options' and experiment with the 'Aggregate Value Function' (such as setting it to 'Don't Aggregate' or 'Maximum').
If you still see nulls, prepare a sample of your source table, your desired output, and screenshots of your current pivot settings and grouping columns.
Visit the official Power BI Community forums, create a new post with your gathered diagnostic information, and ask experts to recommend the correct Power Query M code steps for your specific dataset.

Try WPS Office for Your Spreadsheet and Data Preparation Needs
While advanced data modeling requires specialized business intelligence tools like Power BI, WPS Spreadsheet offers a lightweight, fast, and free alternative to Excel for cleaning, organizing, and pivoting your raw data before importing it into BI dashboards. Enjoy full format compatibility and a familiar user interface.
- 1. Open Your Data File: Launch WPS Spreadsheet and open the .csv or .xlsx file containing your raw data.
- 2. Clean and Format Dates: Select your date column, right-click, and choose 'Format Cells' to ensure all dates are uniform.
- 3. Create a PivotTable: Go to the Insert tab, click 'PivotTable', and drag your parameters and dates to group them visually before exporting the clean dataset.

Frequently Asked Questions
Why does pivoting in Power BI create null values?
Null values usually appear during a pivot operation when there isn't a unique, uniform row identifier (like an exact Date) to group the new columns by, or when the aggregate function in the advanced options is set to 'Don't Aggregate' with overlapping data.
How do I prevent nulls when grouping by date in Power Query?
Ensure your Date column has no hidden time variations. You may need to change the column type to 'Date Only' rather than 'Date/Time' before performing the pivot operation so all matching records group into a single consolidated row.
Can I use WPS Spreadsheet to pivot data before importing to Power BI?
Yes, you can use WPS Spreadsheet to clean, organize, and create PivotTables for your raw data. Once summarized, you can save the data as an .xlsx or .csv file and import it directly into Power BI.




