Skip to main content

Power BI

Needs Votes

Extend DAX Format Function for colors

Vote (1390) Share
David Godri's profile image

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)
David Godri's profile image Profile Picture

Anwesh Gangula on 16 Aug 2020 04:00:53

RE: Extend DAX Format Function for colors

Really would help in highlighting necessary infomation

David Godri's profile image Profile Picture

Sean-Paul Cottone on 16 Aug 2020 04:00:11

RE: Extend DAX Format Function for colors

This would be wonderful beneficent to customize reports

David Godri's profile image Profile Picture

Jonas Sousa on 16 Aug 2020 03:59:50

RE: Extend DAX Format Function for colors

PLEEEEASSEEE! HELP ME...