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.
Hi Steev_Marcial ,
Thank you for reaching out to the Microsoft Fabric Community Forum.
We really apologies for the inconvenience, after reviewing the issue, there was a small typo in the M code the opening quote for "column17" was missing.
It was written as column17" instead of "column17", which could lead to syntax errors or unexpected behavior. Please make sure all column names are enclosed within proper double quotes.
The dates in your two screenshots do not match. Please check using the same date in both screenshots to verify whether the null values are appearing correctly or not.Verify that all columns in the table are using the correct data types, as mismatches can lead to null values or errors in the data view.
As shown in the second screenshot it is shown only April months data does it show the same for every month could you please confirm.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
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.
Hi Steev_Marcial ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the query is resolved, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank youHi Steev_Marcial ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.