Power Bi Pivot Table

[Excel Fox]

Hi I have a a table and have pivoted a column to give the column headers and taken a date column to fill them. Where no dates exists it is giving the value as "null". Is there a way to then remove the null so it is a blank cell?

 

[severynm]

In the context of the Power Query editor, null definitely the preferred value. In your column, null is the equivalent of no data point (no date), while a blank would be the equivalent of a date of "".

See: Nuthin' ain't nuthin' in Power Query - The Excelguru Blog

 

[Excel Fox]

Hi yes there is no date for every one of the new columns. Is there a way to remove the nulls so like an excel sheet they would be blank?

 

[alansidman]

In Power Query, on the Transform Tab, select replace and then fill in null and leave the second box blank.

If you do nothing, then when you Close and Load to Excel Native, the nulls appear as blanks when using PQ.