Forum Discussion
Sort with DAX Function FORMAT
Amit_Saxena wrote:
How can i get this "table properties formatting feature" enable in power bi desktop, i can't see that?
The UI has changed a bit since this thread started. In either of the report view or data view, if you click on a numeric column (in the screenshot below I clicked on the "FromDistance" column) you will see a "column tools" ribbon appear. The formatting options are in that ribbon.
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"), now format is converting this inot string and i can't sort that measure 'xyz' in table, though if i use the value function to convert this like value (Format ([Measure1] ,"#,.0,K")) then it works but there is another problem, now if i use any filter to filters the values let say based on Region then table doesn't show any data and error message says can't convert value xxxxxxK of type text to Number. Pls suggest!
Thanks,
Amit
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!!!