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

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

RE: Extend DAX Format Function for colors

Will be Huge help to conditionally format data within Custom Visuals where we don't have that option

David Godri's profile image Profile Picture

Richard Cousins on 16 Aug 2020 04:19:33

RE: Extend DAX Format Function for colors

This would be a huge help for dynamic story telling

David Godri's profile image Profile Picture

Power BI User on 16 Aug 2020 04:19:24

RE: Extend DAX Format Function for colors

This would be very helpful.

David Godri's profile image Profile Picture

Andrew Goldman on 16 Aug 2020 04:19:22

RE: Extend DAX Format Function for colors

Please make this happen!

David Godri's profile image Profile Picture

DERECK LUIZ PEREIRA on 16 Aug 2020 04:19:12

RE: Extend DAX Format Function for colors

Do it! Do it NOW!

David Godri's profile image Profile Picture

Power BI User on 16 Aug 2020 04:19:08

RE: Extend DAX Format Function for colors

yes that would be useful

David Godri's profile image Profile Picture

Power BI User on 16 Aug 2020 04:19:06

RE: Extend DAX Format Function for colors

Please add this functionality, it would be great!

David Godri's profile image Profile Picture

Carly Bond on 16 Aug 2020 04:19:05

RE: Extend DAX Format Function for colors

Would be a really useful piece of functionality

David Godri's profile image Profile Picture

Power BI User on 16 Aug 2020 04:19:03

RE: Extend DAX Format Function for colors

Much needed function.

David Godri's profile image Profile Picture

Roma on 16 Aug 2020 04:18:59

RE: Extend DAX Format Function for colors

Yes, It is a much-needed feature. Please add this.