Forum Discussion
Sort with DAX Function FORMAT
Hello All. Does anyone know when the bug will be fixed for sorting measure values that have the FORMAT() function applied to them?
Amit_Saxena wrote:
Thanks But that doesn't allow me to format the text in refect these values in thousands, Actually i have sales values appearing in millions and these have to represent in thousand or amusing it like xyz= Format ([Measure1] ,"#,.0,K"),
Yes it does. You can just type in your custom format string. Both measures have the same expression in the example below, I just used a custom format string on the second one.
Super! it works!! Thanks alot!!!