Power BI

Needs Votes

Extend DAX Format Function for colors

Vote (1390)

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)

Comments (83)

Shivani Borkar on 30 Aug 2024 11:12:19

RE: Extend DAX Format Function for colors

This is very good and demanding when you need to show the Label in normal text and the value for that label in bold in the Text titles or table, i have the same requirement.Can we get this feature asap. will be great Thankyou.

Jason Flindall on 22 Jul 2024 22:48:21

RE: Extend DAX Format Function for colors

This feature would greatly extend the potential for Reference Labels to communicate contextual information in the new Cards visual. Please implement this idea!

François Delepoulle on 08 Jul 2024 13:43:21

RE: Extend DAX Format Function for colors

Please, that would be a game changer especially in matrices and tables !

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.