Forum Discussion
Filtering issue of null data
hello Steev_Marcial
the m-code only show changing value type and rename header (no filter row).
maybe the PQ visual has not been refreshed so it shows the old data while the data loaded into PBI is the latest one.
maybe try checking your file in sharepoint.
otherwise, sharing a partial of your data in sharepoint (in particulary the date and value column) might help comunity to identify the cause.
Thank you.
Hello.
For column17 it's just a typing mistake when I was replacing column names with dummy column titles.
However, the dates that do not match in both screenshots is the issue that I am having; in the first screenshot from power query, everything is fine, with data showing from January onwards, but in the table view, the lines with the values do not appear and hence the data starts from April (we update the data daily). So somewhere there is a filter that I could not find which filters filled values and show only null values (i.e. dates not yet filled, for example if we are on April 17th, data on April 15th will not be visible, but null values for April 18th will be visible because not yet completed)
hello Steev_Marcial
the m-code only show changing value type and rename header (no filter row).
maybe the PQ visual has not been refreshed so it shows the old data while the data loaded into PBI is the latest one.
maybe try checking your file in sharepoint.
otherwise, sharing a partial of your data in sharepoint (in particulary the date and value column) might help comunity to identify the cause.
Thank you.