The ability to provide specify the Data Colour for each item in the Legend field. E.g. a column from the data source in which to specify the colour e.g. #A66999 for each item in the Legend field.
This would apply to all the standard charts, e.g. bar, column, line chart, any of the charts with the Legend property.
Administrator on 02 May 2019 04:01:43
Near the end of last year we upgrade visuals to use conditional formatting just like tables. This means you can take advantage of "By field" formatting to do exactly what this idea requested. Create a field in your model assigning colors, and then use the conditional formatting dialog for colors to format it. Here's the original announcement post. Do note that the UI has changed some in recent months, but the functionality is the same: https://powerbi.microsoft.com/blog/power-bi-desktop-november-2018-feature-summary/#conditionalFormatting
- Comments (35)
RE: Dynamically specify Data Colour using column e.g #A66999.
This would be really useful to flow through from the data generating host app where colour codes are a user input
RE: Dynamically specify Data Colour using column e.g #A66999.
please included the template -color as a new feature for PowerBI
Thanks,
RE: Dynamically specify Data Colour using column e.g #A66999.
This is really important for us!... having to manually update chart colors for each category on every new pbix is extremely tedious - we have standardized colors at our company, and this feature seems so basic - the competitors have it!
It would also really help the adoption of the tool....
RE: Dynamically specify Data Colour using column e.g #A66999.
easy, switch to SF! Why bothering with this? Sorry, I mean Tableau
RE: Dynamically specify Data Colour using column e.g #A66999.
And also please include this new feature in the power BI desktop as we want to use power bi embedded
RE: Dynamically specify Data Colour using column e.g #A66999.
When I read this article https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tips-and-tricks-for-color-formatting/#use-diverging-color-scales I tought that I can do whatever I want with values, I have a customer that need this feature please consider it for the next releases.
RE: Dynamically specify Data Colour using column e.g #A66999.
This would allow us to provide consistent colors across SSRS and Power BI creating a seamless experience.
RE: Dynamically specify Data Colour using column e.g #A66999.
This would be a very useful feature in building dashboards with consistent color formatting across multiple reports.
RE: Dynamically specify Data Colour using column e.g #A66999.
I can't understand why the custom and conditional formating in Power BI it's so problematic. This a basic feature in any modern dashboard/reporting tool.
Every monthly updated, Microsoft add more features to Power BI, but this basic and fundamental item, it's not considerated. I don't know why.
RE: Dynamically specify Data Colour using column e.g #A66999.
I would be happy if Power BI simply allowed one to type out all six characters of a custom color at once without switching off the dialog box. As it stands you can only type three characters at a time.