Skip to main content
Microsoft Idea

Power BI

Needs Votes

Extend DAX Format Function for colors

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

Micah on 16 Aug 2020 04:12:28

RE: Extend DAX Format Function for colors

Yes, this is absolutely needed.

David Godri's profile image Profile Picture

Power BI User on 16 Aug 2020 04:10:30

RE: Extend DAX Format Function for colors

I'l like to see this feature as well.

David Godri's profile image Profile Picture

Power BI User on 16 Aug 2020 04:09:56

RE: Extend DAX Format Function for colors

I need this feature

David Godri's profile image Profile Picture

Wesley Fletcher on 16 Aug 2020 04:09:41

RE: Extend DAX Format Function for colors

Please add this functionality

David Godri's profile image Profile Picture

Christopher on 16 Aug 2020 04:08:43

RE: Extend DAX Format Function for colors

This could improve the appearance of Parameter documentation.

David Godri's profile image Profile Picture

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

RE: Extend DAX Format Function for colors

i need this feature

David Godri's profile image Profile Picture

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

RE: Extend DAX Format Function for colors

Yes this functionality is good to have.

David Godri's profile image Profile Picture

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

RE: Extend DAX Format Function for colors

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

Power BI User on 16 Aug 2020 04:01:10

RE: Extend DAX Format Function for colors

I really need this one

David Godri's profile image Profile Picture

Anwesh Gangula on 16 Aug 2020 04:00:53

RE: Extend DAX Format Function for colors

Really would help in highlighting necessary infomation