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.
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,