david_godri's avatar
david_godri
New Member
8 years ago
Status:
Needs Votes

Extend DAX Format Function for colors

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

85 Comments

Recent ideas