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

d52044ef 90ed-451b-ac77-6dc94a9b45f6 on 16 Aug 2020 04:20:31

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

This would be super helpful for better storytelling! Do it, please!

David Godri's profile image Profile Picture

f3b32a75 b8e4-42e4-9303-fb25858676bd on 16 Aug 2020 04:20:30

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

Really need this. The current color formatting options are not granular enough

David Godri's profile image Profile Picture

98a70bea 764d-48fc-97c3-42c54cb0d87a on 16 Aug 2020 04:20:04

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

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

f4fa22dd 9b23-4824-aae5-ed5d514a5200 on 16 Aug 2020 04:19:33

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

This would be a huge help for dynamic story telling

David Godri's profile image Profile Picture

e298531f f712-40f1-9110-6f1289165aa9 on 16 Aug 2020 04:19:24

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

This would be very helpful.

David Godri's profile image Profile Picture

a2e2d28b 8dd2-ea11-a812-000d3a563be2 on 16 Aug 2020 04:19:22

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

Please make this happen!

David Godri's profile image Profile Picture

5b7902b0 e096-4e57-ae28-459e47b32f96 on 16 Aug 2020 04:19:12

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

Do it! Do it NOW!

David Godri's profile image Profile Picture

b3b6effe 5a8f-4cfa-9cb9-c198518a09ef on 16 Aug 2020 04:19:08

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

yes that would be useful

David Godri's profile image Profile Picture

cf752844 bab5-4437-b1ee-20243a9d2d81 on 16 Aug 2020 04:19:06

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

Please add this functionality, it would be great!

David Godri's profile image Profile Picture

c26ce03b d7d7-4d49-98ea-616e1fb835d4 on 16 Aug 2020 04:19:05

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

Would be a really useful piece of functionality