Forum Discussion

Steev_Marcial's avatar
Steev_Marcial
Regular Visitor
1 year ago
Solved

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 mo...
Tips and Tricks
  • Irwan's avatar
    Irwan
    1 year ago

    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's avatar
danextian
Super User
1 year ago

Hi Steev_Marcial 

 

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

Steev_Marcial's avatar
Steev_Marcial
Regular Visitor
1 year ago

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"