Forum Discussion
Table visual displaying zero (nil) values even when filtered value Is not 0.
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}})
Thanks for the pbix.
I don't have time to give a full response but, initially, when I see these types of issues, I immediately think of the precision of decimal numbers and how they look in a visual compared to what their 'actual' values are. 0 is not always 0.00, sometimes it is 0.00000012, for example. (0.0000012 is not 0 hence the rows are not filtered out)
That is the reason the visual is showing you rows with 0 in them (you can prove that by increasing the number of decimal places (click on the amount field, go to the 'formatting' bar on the ribbon, it'll be set to Auto so put it to 8 or something and the values will appear). <- edit (it actually has to be around 13 places)
So, you can fix it by using a currency / fixed decimal data type which will limit to 2 decimals and won't contain the tiny values.
--
I can have a look at the other visual later. I expanded the decimal places and the values are coming through as 0.0000000 (which is equal to zero, so the rows WILL be filtered out). So there will be a difference in the two queries which I don't have time to look at right now
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}})