3

Format Percentage in 100% Stacked Bar

I have a 100% Stacked Bar that I have turned on the Data Label and switched it to show the percentage.  Can I format the percentage to no decimal places or just 1 decimal?

I was not able to figure out if it was possible to modify the format.

1 reply

null
    • burgundy_rose
    • 1 yr ago
    • Reported - view

    Hi Jason,  

    It can be achieved with the following steps.

    Create a custom measure whose value is "me as a percentage of the whole".  Be sure to set the desired format string in its properties.

    (Syntax: [measures].[Sales]/(AllMembers([Date].[year]),[measures].[Sales]) )

     

    Then use the newly created measure in the discovery as follows:

     

    Hope this helps,

    Ez

Login to reply

Content aside

  • Status Answered
  • 3 Likes
  • 1 yr agoLast active
  • 1Replies
  • 55Views
  • 3 Following