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
Custom visuals: allow same-tab navigation & reduce confirm-navigation friction for trusted links
Description: Custom visuals (e.g. Deneb) that trigger navigation via href currently have two limitations that create friction for legitimate, author-controlled use cases: Links always open in a ne...AlexSenEON1 hour agoNew MemberNew5Views0likes0CommentsSeparate Download and Publish Permissions for Power BI Workspaces
Idea / Feature Request Introduce more granular permissions in Power BI to independently control report download and report publishing permissions at the workspace level. Business Scenario We have ...ewarstdhyjugkhi2 hours agoMicrosoft EmployeeNew19Views8likes0CommentsSupport Fabric SQL Database with workspace-level inbound Private Link
Fabric SQL Database supports tenant-level Private Link but not workspace-level Private Link. Securing a small number of databases therefore requires enabling Private Link across the entire tenant, in...WorkFull223 hours agoAdvocate INew31Views1like1Comment