Forum Discussion

prakash11440278's avatar
prakash11440278
Post Prodigy
3 years ago

Format function display issue in y - axis

Hi All,

My requirement is to convert the decimal value into billion format. Where i am able to acheive using the below expression. But it is replecting wrong in y axis labels, that i dont want to add in axis section. Please help.

Measure = format(sum(sales[salesamount]),"$#,,,.##B")

 

2 Replies

  • Hi prakash11440278 ,

     Depending on the visual, you may be able to use the original measure and just change the display units like below:

     

    Please consider accepting as solution if this has answered the question.

     

    • prakash11440278's avatar
      prakash11440278
      Post Prodigy

      djurecic Thanks for your reply.

      I tried the above provided solution but it is not worked. I am using line chart when i hover the visual it is displaying full numeric value instaed of this i need to show like "1.24bn" without altering the yaxis labels.