Skip to main content
Microsoft Idea

Power BI

Needs Votes

Extend DAX Format Function for colors

Vote (1322) 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

Andreu fil on 19 Apr 2024 09:36:54

RE: Extend DAX Format Function for colors

Good information, thanks


sehackear.top

David Godri's profile image Profile Picture

elias zafrani on 18 Apr 2024 23:04:25

RE: Extend DAX Format Function for colors

Thanks


Hackear Instagram

Hackear WhatsApp

Hackear Facebook

David Godri's profile image Profile Picture

Akhil Thomas on 08 Feb 2024 05:13:28

RE: Extend DAX Format Function for colors

Please enable this feature

David Godri's profile image Profile Picture

Katharina Schwarzer on 30 Jan 2024 09:41:45

RE: Extend DAX Format Function for colors

this would easen up a LOT of lifes - PLEASE consider to implement this. Using conditional formatting hundreds of times when using the same field/measure very often on a dashboard, just to make negatives reed, is SO annoying and time consuming. My customers would really LOVE this feature.

David Godri's profile image Profile Picture

LeGrand Johnson on 22 Dec 2023 21:12:17

RE: Extend DAX Format Function for colors

Please, please implement this asap!

David Godri's profile image Profile Picture

Andrew Martin on 13 Nov 2023 16:41:50

RE: Extend DAX Format Function for colors

Yes please

David Godri's profile image Profile Picture

Frank Dylla on 24 Oct 2023 12:07:03

RE: Extend DAX Format Function for colors

Please, make it available soon!

David Godri's profile image Profile Picture

Gagan Yadav on 20 Oct 2023 00:13:26

RE: Extend DAX Format Function for colors

How many votes does Microsoft need to take any idia to implementation stage? Hope we soon the formatting as part of DAX.

David Godri's profile image Profile Picture

Pilar Serrano on 12 Sep 2023 15:58:50

RE: Extend DAX Format Function for colors

Hope it is ready soon. I really need it

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.