Amanda
Microsoft Employee
11 years agoStatus:
Completed
Set Colors and Conditional Formatting in visuals
Power BI's visualizations have colors assigned automatically. It should be possible to set a color when a value is reached (e.g. always show negative bars in red) or for a particular color in a legend (e.g. always show Microsoft datapoints as blue)
71 Comments
- Derek9New MemberAlong these same lines, a more fine-grain control of formatting in general should be at the top of the list. Many clients won't even consider a reporting solution that doesn't match certain color patters exactly. I think this is the main thing preventing most people that I've talked to from adopting this tool. This forces me back to excel where I can control details.
- pedro8New MemberYes! Please make sure we can specify colours based on built-in or custom themes (e.g. accent colour #1) or to override them completely by specifying a direct colour (either through a picker or by specifying the HEX value). So basically making the whole colouring experience more aligned to Office Applications. I second Sam Carroll's comments about Power View as well. It is quite embarrassing to explain to end users that we can't change the colour of charts. So this is something that should be pushed to on-prem deployments as well. Also since we are on the subject, please let us specify things such as borders and their sizes, line format, shape (e.g. round edges, etc).
- sam_carrollNew MemberOne of the biggest requests we currently get for our on-premise BI solution is that users want to be able to directly change the colors of specific items in a Power View report. (We have certain operational colors that are company standard and need to be enforced). Adding this in to Power BI would save me a ton of headaches explaining to engineers that 'No, we can't change a simple color for you'.
- dsladeNew MemberTo echo all the comments already posted - the lack of color customization is the single biggest factor in preventing clients, particularly large enterprise clients, from adoption.
- juan5New MemberIn Gauges we need to handle at least 3 colors: green, red, yellow. Formating numbers it's a most for the customers
- v-nickscNew MemberBeing unable to set series colors in charts is a fundamental barrier to using PowerBI at all versus a bunch of pivot charts on a worksheet.
- shantha053New MemberThis is a key feature for many organizations and the reason for using other BI tools.
- prakash_motwaniNew MemberHonestly, we're dropping PowerBI usage just because we can't customize this as per our Corporate UI Standards. When complete, can you please inform and we can evaluate again?
- colin2New MemberIn my experience, it's almost impossible to convince clients to consider Power BI without the ability to specify color. I'll be using Excel pivot charts and Tableau for now, because these products have the ability to customize a chart.
- youyhya
Advocate I
Any updates on this item??
Recent ideas
Blocker: Purview must scan Fabric Warehouse tables/columns or we will deprecate Purview
Purview + Fabric Warehouse ≠enterprise‑ready governance. In our environment, the Fabric Warehouse is the system of record, but Purview can only catalog the warehouse container—not the tables or co...Joshua_Hernande6 minutes agoNew MemberNew161Views1like1CommentPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes8 hours agoNew MemberNeed Clarification198Views3likes1CommentParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v8 hours agoCommunity ChampionNeeds Votes36Views2likes1CommentExpose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_8 hours agoNew MemberAbandoned27Views0likes2CommentsExpose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer10 hours agoAdvocate INew1.2KViews26likes2Comments