Search for answers here or ask a question
0

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.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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

    Like
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 1Replies
  • 19Views
  • 2 Following