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
85 Comments
- jssantosNew MemberPLEEEEASSEEE! HELP ME...
- gangulaanweshNew MemberReally would help in highlighting necessary infomation
- Sean-Paul_CottoNew MemberThis would be wonderful beneficent to customize reports
- rio_sucitraNew MemberI really need this one
- josipinho
Helper II
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 ! - ismailsFrequent Visitori need this feature
- Christann
Advocate IV
This could improve the appearance of Parameter documentation. - nayanrathi28aprNew MemberYes this functionality is good to have.
- barosmotaNew MemberI need this feature
- wesfletcherFrequent VisitorPlease add this functionality
Recent ideas
Justification Prompts When Downgrading or Removing Sensitivity Labels in Power BI Desktop
Description Currently, organizations can configure Microsoft Purview sensitivity label policies to require users to provide a justification when removing a label or lowering its classification. T...vvargasv8 hours agoMicrosoft EmployeeNew9Views0likes0CommentsVisual Type Defaults in Visualization Pane
This would change my life with fussy clients and client/public facing apps. In addition, it would allow me to add more value to the clients on retainers who do not have the 'hours' to allocate to...IolaWhiteley9 hours agoAdvocate IINew44Views7likes0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente9 hours agoRegular VisitorNew78Views6likes1CommentAllow Bookmarks to Affect Multiple Report Pages
Description: I would like to request the ability for a single Power BI bookmark to affect and maintain a state across multiple report pages, rather than being limited to a single page. For example,...Josegonzalez219 hours agoNew MemberNew20Views4likes1CommentFeature Proposal: Expandable/Collapsible Page Sections for Reports on Same Semantic Model
Subject: Feature Proposal: Expandable/Collapsible Page Sections for Reports Using the Same Semantic Model Dear Microsoft Power BI Team, I would like to propose an enhancement to the Power BI report...Dr7awb9 hours agoNew MemberNew32Views1like1Comment