Unable to add % Measure as a value in a clustered column chart

[Anonymous]

Hello,

I am a beginer user of Power BI and hoping that anyone can give me some insights to solve one of the issues that I am currently facing!

I am developing a HR dashboard and would like to create a bar graph showing % of employees who are over 52 years old by business unit to see a retirement risk for the organisation. I have created a measure of a proportion of employees who are over 52 years old as follows.

% Retiring >52 = FORMAT(CALCULATE(SUM('Employee Profile'[Headcount]),'Employee Profile'[Retiring (>52)] IN { "Over 52" })

/ SUM('Employee Profile'[Headcount]),"Percent")

And then I tried to use the measure in a clustered column chart, however, it does not let me add the measure as a value (but as a tooltip).

Your help and advice would be appreciated.

Regards,

[mattneil · Accepted solution]

Hi @Anonymous 

That's happening because using the FORMAT() function returns a text string, which it why the visual won't accept it in the value field. 

To format as a percentage, select the measure then in the ribbon menu go to the Modeling tab and change the Format to Percentage

Cheers,

Matt 

[Anonymous]

Thank you so much - it worked! Very much appreciated.