Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |