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

Darin Tuttle on 16 Aug 2021 23:57:07

RE: Extend DAX Format Function for colors

yes please would be great

David Godri's profile image Profile Picture

Isabel Ballinger on 02 Aug 2021 04:25:18

RE: Extend DAX Format Function for colors

This would be really useful for formatting commentary to make it easier to read, as an example

David Godri's profile image Profile Picture

JJ AE on 23 Jun 2021 01:32:06

RE: Extend DAX Format Function for colors

Please, enable this function!

David Godri's profile image Profile Picture

Jeff Gallagher on 30 Apr 2021 14:32:45

RE: Extend DAX Format Function for colors

Would be a handy addition

David Godri's profile image Profile Picture

Damien Decoene on 26 Mar 2021 08:07:46

RE: Extend DAX Format Function for colors

I really need this

David Godri's profile image Profile Picture

Sunil Tak on 18 Feb 2021 10:28:47

RE: Extend DAX Format Function for colors

I can see ,this is created in 2017 , more than 3 years. Please implement this feature soon or please let us know when this will be in your priority.

Thanks

David Godri's profile image Profile Picture

More Insights on 03 Dec 2020 23:14:00

RE: Extend DAX Format Function for colors

This would be really useful, please implement this.

David Godri's profile image Profile Picture

Orsolya Vizi on 16 Aug 2020 04:20:31

RE: Extend DAX Format Function for colors

This would be super helpful for better storytelling! Do it, please!

David Godri's profile image Profile Picture

Power BI User on 16 Aug 2020 04:20:30

RE: Extend DAX Format Function for colors

Really need this. The current color formatting options are not granular enough

David Godri's profile image Profile Picture

Power BI User on 16 Aug 2020 04:20:04

RE: Extend DAX Format Function for colors

Will be Huge help to conditionally format data within Custom Visuals where we don't have that option