Amanda Rivera on 04 Oct 2014 01:20:39
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)
- Comments (70)
RE: Set Colors and Conditional Formatting in visuals
This is a key feature for many organizations and the reason for using other BI tools.
RE: Set Colors and Conditional Formatting in visuals
power bi would be useless without the option to customize colors and charts... how should anyone use it in an proffessional context without this feature ?
please implement it.
RE: Set Colors and Conditional Formatting in visuals
Any updates on this item??
RE: Set Colors and Conditional Formatting in visuals
In 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.
RE: Set Colors and Conditional Formatting in visuals
Being 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.
RE: Set Colors and Conditional Formatting in visuals
In Gauges we need to handle at least 3 colors: green, red, yellow. Formating numbers it's a most for the customers
RE: Set Colors and Conditional Formatting in visuals
To 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.
RE: Set Colors and Conditional Formatting in visuals
Along 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.
RE: Set Colors and Conditional Formatting in visuals
Yes! 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).
RE: Set Colors and Conditional Formatting in visuals
One 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'.