Forum Discussion
Filtering issue of null data
Hello all.
Filters
I am having an issue with my data; only null records are showing in the table view while in power query all the data is visible, and this is affecting my daily trend view per month. I tried to locate any filter that is applied, but could not find it. Any tips how this can be corrected would be really helpful.
View in power query: data since January visible
View in table view: only empty data is showing.
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.
9 Replies
Hello danextian.
Below is the M code:
let
Source = Excel.Workbook(Web.Contents("https://domain.sharepoint.com/sites/subsite/Shared%20Documents/documentname.xlsx"), null, true),
DataPbi_Table = Source{[Item="DataPbi",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(DataPbi_Table,{{"DATE", type date}, {"column1", Int64.Type},{"column2", Int64.Type}, {"column3", Int64.Type}, {"column4", Int64.Type}, {"column5", Int64.Type}, {"column6", Int64.Type}, {"column7", Int64.Type}, {"column8", Int64.Type}, {"column9", Int64.Type}, {"column10", type number}, {"column11", Int64.Type}, {"column12", Int64.Type}, {"column13", Int64.Type}, {"column14", Int64.Type}, {"column15", Int64.Type}, {"column16", type number}, {"column17", type number}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{column17", "newname1"}, {"column16", "newname2"}, {"column15", "newname3"}, {"column14", "newname4"}, {"column13", "newname5"}, {"column12", "newname6"}, {"column11", "newname7"}, {"column10", "newname8"}})
in
#"Renamed Columns"
Hi 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.
I haven't resolved the issue yet
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.
