Skip to main content

Power BI

Needs Votes

Extend DAX Format Function - Simple, but HUGE Benefits

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

033b5240 228a-4699-8cf6-19069f15c6a5 on 16 Aug 2020 04:14:56

RE: Extend DAX Format Function - Simple, but HUGE Benefits

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

David Godri's profile image Profile Picture

1e0f8950 1a0c-44ad-b097-7d31b6e22407 on 16 Aug 2020 04:13:00

RE: Extend DAX Format Function - Simple, but HUGE Benefits

Would be absolutely helpful in highlighting key info from text.

David Godri's profile image Profile Picture

ec9b48d5 9041-4896-bc90-13f0ac688776 on 16 Aug 2020 04:12:54

RE: Extend DAX Format Function - Simple, but HUGE Benefits

This would really help the readability of my tiles

David Godri's profile image Profile Picture

851c6969 a0bb-4bec-ac8c-de2e51e9ce1c on 16 Aug 2020 04:12:28

RE: Extend DAX Format Function - Simple, but HUGE Benefits

Yes, this is absolutely needed.

David Godri's profile image Profile Picture

ddcb4a1b ab49-4860-bd7e-c8ab5640b96e on 16 Aug 2020 04:10:30

RE: Extend DAX Format Function - Simple, but HUGE Benefits

I'l like to see this feature as well.

David Godri's profile image Profile Picture

e2bf0d68 081d-436a-bd4a-ebcd3bbb1e4e on 16 Aug 2020 04:09:56

RE: Extend DAX Format Function - Simple, but HUGE Benefits

I need this feature

David Godri's profile image Profile Picture

9c3dae7d 8c37-4998-b583-143b9da1bc3f on 16 Aug 2020 04:09:41

RE: Extend DAX Format Function - Simple, but HUGE Benefits

Please add this functionality

David Godri's profile image Profile Picture

9ae47809 b671-4b43-8b7b-ea83968ab771 on 16 Aug 2020 04:08:43

RE: Extend DAX Format Function - Simple, but HUGE Benefits

This could improve the appearance of Parameter documentation.

David Godri's profile image Profile Picture

2ff47e06 68f2-4ef8-a671-423ff6430bd6 on 16 Aug 2020 04:08:35

RE: Extend DAX Format Function - Simple, but HUGE Benefits

i need this feature

David Godri's profile image Profile Picture

2baa3aeb 1884-4628-8596-4ee28c64f574 on 16 Aug 2020 04:08:19

RE: Extend DAX Format Function - Simple, but HUGE Benefits

Yes this functionality is good to have.