Forum Discussion
DAX Format amount with auto display units
Hi,
In a calculated measure, I have a amount field calculated and append with some custom string. I want to format numeric portion of measure with auto display units. When i use "$#,##0,,M" as format spec it displays with million always even values are lesser than million. Is there auto display units in DAX instead of specifying as million in format string ?
Hi Anonymous ,
Based on my research, I am afraid you could not achieve this feature currently:
https://docs.microsoft.com/en-us/dax/format-function-dax
Maybe you could submit an idea in ideas forum:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Daniel He
3 Replies
v-danhe-msftMicrosoft Employee
Hi Anonymous ,
Based on my research, I am afraid you could not achieve this feature currently:
https://docs.microsoft.com/en-us/dax/format-function-dax
Maybe you could submit an idea in ideas forum:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Regards,
Daniel He
- v-danhe-msft
Hi Anonymous ,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?Regards,
Daniel He
- Composed_MS
Helper I
Hello,
Does anybody have a solution for this?