Power BI

Needs Votes

Extend DAX Format Function for colors

Vote (1323)

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 (82)

Comments (82)

Donna MacKenzie on 19 Jul 2023 03:30:13

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.

Derrick Mike Monera on 20 Jun 2023 00:26:30

RE: Extend DAX Format Function for colors

Hope this additional functionality for FORMAT function soon be available as this is a HUGE help!

Derrick Mike Monera on 07 Jun 2023 05:53:37

RE: Extend DAX Format Function for colors

Any updates on this feature? is it a MUST HAVE

Danika LaBella on 18 May 2023 18:09:51

RE: Extend DAX Format Function for colors

This idea has over 1,000 votes and the status is still needs votes? Really?

Roman Raykov on 17 May 2023 11:33:23

RE: Extend DAX Format Function for colors

Hope Microsoft can get around this and do it. It is simple, but effective, brings reporting to another level and opens up a whole spectrum of possibilities. This is a feature that e.g. is available in MATOMO.