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)
RE: Extend DAX Format Function - Simple, but HUGE Benefits
Much needed function.
RE: Extend DAX Format Function - Simple, but HUGE Benefits
Yes, It is a much-needed feature. Please add this.
RE: Extend DAX Format Function - Simple, but HUGE Benefits
Yes it's required to have a nice formated text based on dax formula
RE: Extend DAX Format Function - Simple, but HUGE Benefits
Its will work perfectly and helpful
RE: Extend DAX Format Function - Simple, but HUGE Benefits
it helps to customize the measures
RE: Extend DAX Format Function - Simple, but HUGE Benefits
I vote yes to this!
RE: Extend DAX Format Function - Simple, but HUGE Benefits
Please, how come this is not available?
RE: Extend DAX Format Function - Simple, but HUGE Benefits
I vote for this please.
RE: Extend DAX Format Function - Simple, but HUGE Benefits
Since the whole purpose of Power BI is to simplify and expedite the process of analyzing data, allowing formatting to color code items is a must-have. Careful reading of the details takes a lot of painstaking time that is supposed to be solved by robust visualization software.
RE: Extend DAX Format Function - Simple, but HUGE Benefits
This would really help the readability of my tiles