Clara on 06 Nov 2018 20:57:37
The FORMAT () function should be extremely flexible for conditionally formatting measures based on slicers and so on. But right now not even chart visuals agree with it. Please fix it? Pretty please?
- Comments (35)
RE: Option to FORMAT () values as numbers (not strings)
Can't believe this isn't supported already! I want to use a dynamic measure that switches between Sales and Units (using FORMAT to convert between "$#,##0" and "#,##0.00"). The measure works beautifully, but I lose the ability to sort the table because it is now recognized as text!
Such a basic feature that is desperately needed. Please fix!
RE: Option to FORMAT () values as numbers (not strings)
Yes, in addition, in Excel, negative number like -12345 can be formatted as a bracketed number (not text) as " (12,345). After formatting negative as bracketed number, it right align with positive numbers as Excel gives a space on far right of positive number to match the closing bracket of negative number. Thanks PBI team for great work but pls PBI team help to achieve this same formatting capability as this is a basic need of any table/matrix visual otherwise it is useless.
RE: Option to FORMAT () values as numbers (not strings)
This is definitely need. At the moment I have to create 3 additional measures for each KPI; MTD %. MTD $, MTD std
RE: Option to FORMAT () values as numbers (not strings)
I support it, too. In MDX you can do it.
RE: Option to FORMAT () values as numbers (not strings)
Yes please, it would enhance reports a huge amount for the format on charts to work dynamically.
RE: Option to FORMAT () values as numbers (not strings)
Very basic function in other BI tools! I support it!
RE: Option to FORMAT () values as numbers (not strings)
I support it.
RE: Option to FORMAT () values as numbers (not strings)
Hi, I definitely support this feature - I expected this to be basic functionality and I was quite disappointed to find out it does not work. Please, fix it. Thanks
RE: Option to FORMAT () values as numbers (not strings)
I am currently developing a Sales report for a multi-national company who has shops from around the world. The Headquarters in Europe wants to see Sales reports in EUR as that's what makes sense to them. However, a big share of the retail revenue is coming from Australia in transaction currency in AUD. Headquarters also fixes the exchange rates that we need to use for reporting purposes. The daily currency market movement is irrelevant as financially reporting is done only monthly. I didn't want to create two different measures like Actual MTD and Actual MTD (EUR). I preferred to use only one measure called Actual MTD.
When we deal with currencies, we always talk currency value and symbol to make sense. So naturally I had to add two parameters and control the calculation and DISPLAY of the Actual MTD:
ShowEuroCurrencyValue = TRUE
ShowEuroCurrencySymbol = TRUE
But the second parameter would expose this Power BI limitation in formatting (converting numeric to text). The solution I came up is instead of changing the format on the measure itself, I had to add a Card on the page at the top to show viewers either AUD or EUR.
Scott
RE: Option to FORMAT () values as numbers (not strings)
Being able to dynamically set the datatype of a measure is key for formatting a column with multi data types. For example, I have a field filled with answers to survey questions. These answers can be anything from dates, text, currency, number, or percentage. I want these values to be displayed in a matrix visual as one column with the appropriate formatting (e.g. $, %, etc)