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 enable this feature
RE: Extend DAX Format Function for colors
this would easen up a LOT of lifes - PLEASE consider to implement this. Using conditional formatting hundreds of times when using the same field/measure very often on a dashboard, just to make negatives reed, is SO annoying and time consuming. My customers would really LOVE this feature.
RE: Extend DAX Format Function for colors
Please, please implement this asap!
RE: Extend DAX Format Function for colors
Yes please
RE: Extend DAX Format Function for colors
Please, make it available soon!
RE: Extend DAX Format Function for colors
How many votes does Microsoft need to take any idia to implementation stage? Hope we soon the formatting as part of DAX.
RE: Extend DAX Format Function for colors
Hope it is ready soon. I really need it
RE: Extend DAX Format Function for colors
Would be great to see this additional functionality for FORMAT function. Will be very useful.
RE: Extend DAX Format Function for colors
Nearly 6 years and 1199 votes. I'd love to know how a request gets onto the roadmap.
RE: Extend DAX Format Function for colors
Hope this additional functionality for FORMAT function soon be available as this is a HUGE help!