Forum Discussion
Anonymous
3 years agoNot applicable
Dax Help
Hi Experts, Below dax measure (Format - Text) is showing percentage in decimals, how we can show the result without decimal part. This dax measure is created for providing dynamic title for charts....
- Anonymous3 years ago
Hi
Use the FIXED Function, as it can round you to a whole number and also return a string
Sale % Title = FIXED([% OF TOTAL SALE],0,1)Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Anonymous
3 years agoNot applicable
Hi
Use the FIXED Function, as it can round you to a whole number and also return a string
Sale % Title = FIXED([% OF TOTAL SALE],0,1)
Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂