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

a2666f4d 19e8-45a2-a6b2-b6c8da7d25f8 on 16 Aug 2020 04:03:00

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

Well this is one way to go about it, but since I've already upvoted all the other ideas with formating might aswell vote this one up too !

David Godri's profile image Profile Picture

86fa0115 20a6-4140-9ce7-1d8594e38df9 on 16 Aug 2020 04:01:10

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

I really need this one

David Godri's profile image Profile Picture

a5b1ef2e c121-469c-8a6a-d55e79c4e87b on 16 Aug 2020 04:00:53

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

Really would help in highlighting necessary infomation

David Godri's profile image Profile Picture

a58f5b80 752a-46d7-a0ac-9c6944fcd9aa on 16 Aug 2020 04:00:11

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

This would be wonderful beneficent to customize reports

David Godri's profile image Profile Picture

5fa295ae 3588-4945-8a8c-ee395045d9b5 on 16 Aug 2020 03:59:50

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

PLEEEEASSEEE! HELP ME...