Forum Discussion
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.
Please help
Sale % Title =
VAR LABEL = [% OF TOTAL SALE],
RETURN
LABEL
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! 🙂
1 Reply
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! 🙂