Displaying a Data Label from a Measure in Percent Format in a line Chart

[Anonymous]

Hi, 

Actually I have a measure which is this: 

Operational Utilization = (SUMX('Hours Table', IF('Hours Table'[Utilization] IN {"SALES"},'Hours Table'[Posted Hours], BLANK()))) / SUM('Hours Table'[Posted Hours])

Which is basically calculating a percentage value. 

I could use the result to visualize it in a graph like this way:

However I would like to display those data labels as a percentage format "##.##%". 

I created another same measure but formatting it to percentage this way: 

Operational Utilization Formatted = FORMAT((SUMX('Hours Table', IF('Hours Table'[Utilization] IN {"SALES"},'Hours Table'[Posted Hours], BLANK()))) / SUM('Hours Table'[Posted Hours]),"00.00%")

If I enter that measure in a data card it displays the correct result in percent format. but If I try to enter that value in a values field in the line chart I can't. 

Don't know what it is... maybe the formatting way I'm using ended up converting the value to a string and the chart doesn't receive those formates in the values field. 

Please help. 

[parry2k · Accepted solution]

@Anonymous you don't to format is manually, change select the measure and on measure tools, change it to %

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[az38 · Accepted solution]

Hi @Anonymous 

just pick your measure in the right pane and set date format as Percentage in Measure tools Ribbon

[parry2k · Accepted solution]

@Anonymous you don't to format is manually, change select the measure and on measure tools, change it to %

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[parry2k]

@Anonymous