Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Extend DAX Format Function for colors

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
Status: Needs Votes
Comments
fbcideas_migusr
New Member
This would be really useful for formatting commentary to make it easier to read, as an example
CONDRRT
New Member
yes please would be great
gin-peng_poh
New Member
please turn on as to compete with other BI tool in market
Mehgan_Evans
New Member
Still needed - please!
yong_jiang
New Member
would be great to have this!
Antony_Fox
New Member
this has been languishing since September 2017 and with my vote sits on 801 How many more are needed for it to be considered!!. This will make automation of standard reports so much easier where only certain values in a sentence needs to change each time the report is run, it would make creation of standardised reports (employee/supplier/product reviews etc..) simple to produce at the click of a slicer without having to make multiple edits and once the spelling is checked on the final version, all versions will be consistent
sudhakar_shanka
New Member
This is needed please...
Eike_Huschbeck
New Member
Please make this happen!
mallesh_gadeppa
New Member

and also formating Bold and Italic

radoshits
New Member

Please enable this function that allows part of a text string to be bold or italic.