Forum Discussion

DazBC's avatar
DazBC
Regular Visitor
2 years ago
Solved

Table visual displaying zero (nil) values even when filtered value Is not 0.

I have a table visual that is displaying nil values even when the sum of amount is filtered to 0. I have reduced my data model to one table with the following headings Accounting Date, AccID, Control...
Need Help
  • DazBC's avatar
    DazBC
    2 years ago

    I managed to resolve it (with a little help from ChatGPT), thank you HotChilli for putting me on the right path, much appreciated.

     

    In Power Query I change the type in my model to : 

    = Table.TransformColumnTypes(#"Renamed Columns",{{"Amount", Currency.Type}})

gmsamborn's avatar
gmsamborn
Super User
2 years ago

Hi DazBC 

 

Upload your pbix to OneDrive, GoogleDrive, WeTransfer, DropBox, etc and share the link (with permissions depending on platform).