Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
688.8 / 1722.00 is 0.4 (or 40%) exactly
However if I filter a visualisation by "less than 0.4" (as I have done on the right hand side of the file below) then the result of 40% is displayed in error.
The file is at https://www.dropbox.com/s/1zsqsk2hexw5rfz/Test%20-%20less%20than%20filter%20being%20treated%20as%20l...
Proof that 688.8 / 1722.00 = 40% exactly (not 39.999999999999.... recurring %):
688.8 / 1722 (original fraction)
6888 / 17220 (multiplied top and bottom of fraction by 10)
2/5 (divided top and bottom of fraction by 3444)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @PowerWhy ,
Can you provide me with your version of Power BI Desktop?
We need this information to submit to the internal icm so that we can fix this issue as soon as possible.
Thanks in advance.
Best regards.
Community Support Team_ Caitlyn