Amanda
11 years agoMicrosoft Employee
Status:
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.
- youyhyaAdvocate IAny updates on this item??
Recent ideas
Data Pipelines - Run only selected activities
For debugging and testing pipeline activities during development, allow us to select one or multiple activities and run only the selected pipeline activities. For example, I'm working on editing ...frithjof_v22 hours agoCommunity ChampionNew618Views11likes2CommentsSemantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v1 day agoCommunity ChampionNew21Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401971 day agoFrequent VisitorNew6Views0likes0Comments