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

Tarun Kulchandra on 09 Aug 2023 15:06:51

RE: Extend DAX Format Function for colors

Would be great to see this additional functionality for FORMAT function. Will be very useful.

David Godri's profile image Profile Picture

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.

David Godri's profile image Profile Picture

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!

David Godri's profile image Profile Picture

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

David Godri's profile image Profile Picture

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?

David Godri's profile image Profile Picture

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.

David Godri's profile image Profile Picture

Suhaib Qazi on 16 May 2023 15:59:42

RE: Extend DAX Format Function for colors

Much needed feature please, thank you!

David Godri's profile image Profile Picture

Tessie Tong on 07 May 2023 04:07:49

RE: Extend DAX Format Function for colors

This is much needed feature!

David Godri's profile image Profile Picture

Omar Rose on 09 Mar 2023 14:22:27

RE: Extend DAX Format Function for colors

I don't understand why this hasn't been done yet.

David Godri's profile image Profile Picture

Baudouin De Keyzer on 15 Feb 2023 08:36:05

RE: Extend DAX Format Function for colors

I don't understand how this is not a feature yet