Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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. 

 

 

 

 

 

  • 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!

  • Hi Anonymous 

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

3 Replies

  • 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's avatar
    az38
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous 

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