David Godri on 22 Sep 2017 20:41:53
Extend Format Function to allow color in format code like in Excel. This would allow far more expressive conditional formatting in formulas. Take it a step further and add codes for bolding, italics and other formatting types. This would allow full flexibility in formatting of reports such as bolding certain rows, etc. Simple change - HUGE benefits! The finance community will thank you greatly!
EXAMPLE:
=FORMAT(1, "[[RED]] #") //formats number as red
=FORMAT(1, "[[#ff0000]] #") //formats number as red (using hex code)
=FORMAT(1, "[[RED;BOLD]] #") //formats number as red and bolds
- Comments (83)
RE: Extend DAX Format Function for colors
Come on this is not a big deal to add, please consider implementing this immediately...
RE: Extend DAX Format Function for colors
This would make users lives a lot simpler. Please implement this. This has been languishing since September 2017 with my vote sits on 877??? Please implement this immediately.
RE: Extend DAX Format Function for colors
This would make so many users' lives a lot simpler. Please implement this!
RE: Extend DAX Format Function for colors
Please enable this function that allows part of a text string to be bold or italic.
RE: Extend DAX Format Function for colors
and also formating Bold and Italic
RE: Extend DAX Format Function for colors
Please make this happen!
RE: Extend DAX Format Function for colors
This is needed please...
RE: Extend DAX Format Function for colors
this has been languishing since September 2017 and with my vote sits on 801
How many more are needed for it to be considered!!.
This will make automation of standard reports so much easier where only certain values in a sentence needs to change each time the report is run, it would make creation of standardised reports (employee/supplier/product reviews etc..) simple to produce at the click of a slicer without having to make multiple edits and once the spelling is checked on the final version, all versions will be consistent
RE: Extend DAX Format Function for colors
would be great to have this!
RE: Extend DAX Format Function for colors
Still needed - please!