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)

Andreu fil on 19 Apr 2024 09:36:54

RE: Extend DAX Format Function for colors

Good information, thankssehackear.top

elias zafrani on 18 Apr 2024 23:04:25

RE: Extend DAX Format Function for colors

ThanksHackear Instagram Hackear WhatsApp Hackear Facebook

Akhil Thomas on 08 Feb 2024 05:13:28

RE: Extend DAX Format Function for colors

Please enable this feature

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.