Skip to main content

Power BI

Needs Votes

Extend DAX Format Function for colors

Vote (1390) 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 (83)
David Godri's profile image Profile Picture

Jean-Pierre Lelièvre on 16 Aug 2020 04:17:22

RE: Extend DAX Format Function for colors

Yes it's required to have a nice formated text based on dax formula

David Godri's profile image Profile Picture

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

RE: Extend DAX Format Function for colors

Its will work perfectly and helpful

David Godri's profile image Profile Picture

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

RE: Extend DAX Format Function for colors

it helps to customize the measures

David Godri's profile image Profile Picture

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

RE: Extend DAX Format Function for colors

I vote yes to this!

David Godri's profile image Profile Picture

Olga Ia on 16 Aug 2020 04:15:34

RE: Extend DAX Format Function for colors

Please, how come this is not available?

David Godri's profile image Profile Picture

Gaurav on 16 Aug 2020 04:15:26

RE: Extend DAX Format Function for colors

I vote for this please.

David Godri's profile image Profile Picture

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.

David Godri's profile image Profile Picture

José Pintor on 16 Aug 2020 04:14:57

RE: Extend DAX Format Function for colors

This would really help the readability of my tiles

David Godri's profile image Profile Picture

Sandy on 16 Aug 2020 04:14:56

RE: Extend DAX Format Function for colors

So basic and i cant believe PBI doesn't already have it.

David Godri's profile image Profile Picture

Bachirou Adama on 16 Aug 2020 04:13:00

RE: Extend DAX Format Function for colors

Would be absolutely helpful in highlighting key info from text.