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.
37 Comments
- 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
- This would be a very useful feature, particularly when Power BI is embedded in another application. It would allow colour formatting information to pass from the host application to a Power BI chart so that the colour used to display the series matches a colour in the host application. Example: A host application manages a number of products and each product has an associated colour. When Power BI reports are created relating to these products, the colour of the series should reflect the colour of the product from the host application. We do this today with Dundas BI but would really like to see this feature in Power BI too.
- This would be awesome, guys!
- Yep, would be very useful - I output color data from my other tools (simulation, 3D and CAD) and would want this to flow into my charts in PowerBI, particularly in embedded applications, it needs to be seamless.
- Any updates regarding this functionality? There are other "Ideas" out there that are specific to implementing dynamic conditional formatting throughout PowerBI. However, this is the only one marked as "Under Review". Allowing a dax statement or a field value ([fontcolor], [cellcolor], etc.) in the visual configs would take this product to the next level in creating custom dashboards and scorecards.
- we need to be able to color code without using a url to a color chip on a shared server somewhere, which has proven unreliable.
- 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.
- 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.
- This would be a very useful feature in building dashboards with consistent color formatting across multiple reports.
- This would allow us to provide consistent colors across SSRS and Power BI creating a seamless experience.
