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
Allow Managed Private Endpoint to be disabled/enabled per notebook
Could notebooks have an option to use or not use the workspace's Managed Private Endpoint (MPE)? MPE can significantly increase notebook startup time, even for notebooks that don't need private conn...frithjof_v10 hours agoCommunity ChampionNew20Views1like0CommentsMatrix: 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 ...Sayurivalente1 day agoRegular VisitorNew80Views6likes1Comment