Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Just as the title says, I am using this function GENERATESERIES(-.05,.10,.005) and 0% is appearing as -0%.
What exactly do I need to do here to have 0% show normally?
Thanks!
Solved! Go to Solution.
Hi @ValueCreate ,
Try changing data-type of your percentage column under MOdelling Tab to Fixed Decimal Number and keep Format to Percentage.
This will get fixed.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @ValueCreate ,
I tried using the same function, but I don't see such behaviour. Can you put some screenshots around what you are seeing?
Thanks,
Pragati
Hi! Sure thing here you go- As you can see on the left when I am on the data page it looks correct. But when I am on the report page and put it in a filter and make it a dropdown, the 0% shows as -0%.
Hi @ValueCreate ,
Try changing data-type of your percentage column under MOdelling Tab to Fixed Decimal Number and keep Format to Percentage.
This will get fixed.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati