Forum Discussion
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...
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}})
Post the pbix on a 3rd party site (a legitimate one please) and put the link here. I'll have a look.
Thank you: Here you go Test Table.pbix