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 (80)
RE: Extend DAX Format Function for colors
Please add ASAP!
RE: Extend DAX Format Function for colors
Agreed, the FORMAT function needs the ability to format text by all the standard text formatting options including, color, bold/italic, strike-through, underline, etc...
RE: Extend DAX Format Function for colors
It is needed .
Thanks
RE: Extend DAX Format Function for colors
Would be helpful when you have a measure coded and then you can set the visual output text to change color as needed - similar to this text box. Please push through...
RE: Extend DAX Format Function for colors
This is an awesome idea! I'm facing some hurdles right now that will be solved by this feature if available.
RE: Extend DAX Format Function for colors
Good idea!
RE: Extend DAX Format Function for colors
This would be amazing! Please.
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!