Skip to main content
Microsoft Idea

Power BI

Needs Votes

Extend DAX Format Function for colors

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

Foster Yeboah Ntim on 30 Mar 2022 16:02:08

RE: Extend DAX Format Function for colors

This would make users lives a lot simpler. Please implement this. This has been languishing since September 2017 with my vote sits on 877??? Please implement this immediately.

David Godri's profile image Profile Picture

Rocco Schenkel on 21 Mar 2022 13:32:46

RE: Extend DAX Format Function for colors

This would make so many users' lives a lot simpler. Please implement this!

David Godri's profile image Profile Picture

Shai Radoshitzky on 27 Jan 2022 19:50:34

RE: Extend DAX Format Function for colors

Please enable this function that allows part of a text string to be bold or italic.

David Godri's profile image Profile Picture

Mallesh Gadeppanavar on 20 Jan 2022 12:03:26

RE: Extend DAX Format Function for colors

and also formating Bold and Italic

David Godri's profile image Profile Picture

Eike Huschbeck on 22 Dec 2021 14:21:51

RE: Extend DAX Format Function for colors

Please make this happen!

David Godri's profile image Profile Picture

Sudhakar Shankar on 25 Nov 2021 13:15:20

RE: Extend DAX Format Function for colors

This is needed please...

David Godri's profile image Profile Picture

Antony Fox on 03 Nov 2021 15:36:42

RE: Extend DAX Format Function for colors

this has been languishing since September 2017 and with my vote sits on 801

How many more are needed for it to be considered!!.

This will make automation of standard reports so much easier where only certain values in a sentence needs to change each time the report is run, it would make creation of standardised reports (employee/supplier/product reviews etc..) simple to produce at the click of a slicer without having to make multiple edits and once the spelling is checked on the final version, all versions will be consistent

David Godri's profile image Profile Picture

Yong Jiang on 15 Oct 2021 03:10:21

RE: Extend DAX Format Function for colors

would be great to have this!

David Godri's profile image Profile Picture

Mehgan Evans on 14 Oct 2021 15:17:08

RE: Extend DAX Format Function for colors

Still needed - please!

David Godri's profile image Profile Picture

GP Poh on 14 Oct 2021 09:02:20

RE: Extend DAX Format Function for colors

please turn on as to compete with other BI tool in market