Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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....
  • Anonymous's avatar
    Anonymous
    3 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! 🙂