I created the possibility to select currency in my report. Via the function FORMAT () I want to dynamicly change the format showing a $ or € sign depending on the currency selection. When using DAX ...
This would be EXTREMELY helpful. I want my negative #s to be formatted in () ... To do this, I use FORMAT([metric], "$#,##0.00;($#,##0.00)"). But now it's recognized as TEXT and not a numeric value... So I have to create 2 measures of EVERYTHING! One that Power BI recognizes as a number (that I can use for math with other metrics) and another that is formatted properly that I can use in the visual. Either allow the FORMAT function to render numeric OR simply allow "Custom" format of any measure/column (instead of only the predefined formats available). Same goes for Dates (I want "Jan '19" or "Jan-19" but these are not in the predefined list.
