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
Very very much needed.. Please do this !!!!
RE: Extend DAX Format Function for colors
it would be extremely helpful!!
RE: Extend DAX Format Function for colors
Would really love this feature!
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.