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)

LONG TRAN GIA on 16 Aug 2020 04:17:20

RE: Extend DAX Format Function for colors

Its will work perfectly and helpful

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

RE: Extend DAX Format Function for colors

it helps to customize the measures

LISA EBARB GOODE on 16 Aug 2020 04:16:08

RE: Extend DAX Format Function for colors

I vote yes to this!

Olga Ia on 16 Aug 2020 04:15:34

RE: Extend DAX Format Function for colors

Please, how come this is not available?

Gaurav on 16 Aug 2020 04:15:26

RE: Extend DAX Format Function for colors

I vote for this please.

Josiah on 16 Aug 2020 04:15:25

RE: Extend DAX Format Function for colors

Since the whole purpose of Power BI is to simplify and expedite the process of analyzing data, allowing formatting to color code items is a must-have. Careful reading of the details takes a lot of painstaking time that is supposed to be solved by robust visualization software.