I'm trying to format a calculation as a percentage in the Colors and Legend: By Measure: Expression Editor section of a Map chart. Can someone tell me if that is possible and if so, how to go about doing it? The basic formula is as follows:
If you create a master measure (Say MyMeasure) first and then select it in the Map property --> Appearance --> Colors and Legend --> Colors (Custom) --> By Measure --> MyMeasure
Will that work for you?
I don't think you need to format the expression which you are using for color.
Still you can try num(count(distinct([Acct]))/sum(TotalEEs),'#,##0.00%').
It wont make any change in format because you are applying it for color expression.
If you want to change the format of number which are displayed on pop up(hover on points) then you will have to use num() in expression used in Measure section of chart.
What I'm trying to display is a combination of two measures. I am using a Point Layer on the Map chart.
The bubble size is based on the number of employees in a group. The Appearance of the bubbles is set in Colors and Legend: Custom, By Measure where the color is chosen based on the result of a calculation of unique customers out of total employees in a group, written as this in the Expression Editor: count(distinct([Acct]))/sum(TotalEEs). We want this number to be expressed as a percentage.
I've tried a number of variations of num(count(distinct([Acct]))/sum(TotalEEs),'#,##0.00%') in the formula, but none of them have an effect on the display of the calculation. Can you think of a way to make this happen, or am I basically out of luck?
It shows the number of employees in the group and a number like 0.15 instead of 15%, which is what we'd prefer to see. Same for the legend--would prefer the numbers be expressed as percentages and not unformated numbers.