Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Number format not working when creating a new measure.

Hello,

 

I have created a new measure called "Days YTD" but for some reason when trying to format this with the comma to separate values, the formatting field appears grayed out and I can not do it. (IMAGE 1)

 

Formula of the measure.

Days YTD = CALCULATE([Total Days], DATESYTD('Calendar Table'[Date]))
 
If I tried to set the measure as percentage, then the formatting pane becomes available (IMAGE 2), but even though I pressed in the comma icon for the measure to have the comma separators,  it does not get any change reflected and the measure remains unformatted, could someone help me to solve this issue?.
 
Many Thanks in advance
 
IMAGE 1

 

IMAGE 2

 
 

 
 
 

 

 

 

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , That is strange. Close and open power BI and Try again.

    Is it possible to share a sample pbix?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello amitchandak I have done that several times hoping to get fixed but it doesn't, It is so frustrating because every measure I am creating is having the same problem. There must be some kind of bug there, after a while playing with the report the data type gets updated to what I selected but it is really annoying, anyway thanks for answer, it looks as if I am the only one having this issue. 

       

      Regards.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    From my test, it is caused by the type of [Total Days] is text. Please check.

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.

     

    Best Regards,
    Eyelyn Qin

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

     

    Best Regards,
    Eyelyn Qin