Number format not working when creating a new measure.

[Anonymous]

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

[v-eqin-msft]

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

[v-eqin-msft]

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

[amitchandak]

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

Is it possible to share a sample pbix?

[Anonymous]

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.