Filtering issue of null data

[Steev_Marcial]

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.

[v-menakakota]

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.

[Steev_Marcial]

I haven't resolved the issue yet

[v-menakakota]

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.

[Steev_Marcial]

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)

[v-menakakota]

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 you

[v-menakakota]

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.

[Irwan · Accepted solution]

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.

[danextian]

Hi @Steev_Marcial 

Can you please post your query (M code)? You can mask the confidiental data.

[Steev_Marcial]

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"