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.
Hello from 2023, dear Microsoft programmers are there any shift on this issue? Or should I ask are there any programmers?
RE: Dynamically specify Data Colour using column e.g #A66999.
Please reopen this idea as it is not complete. It does not work on all visuals.
RE: Dynamically specify Data Colour using column e.g #A66999.
Please, reopen this idea!! Conditional formatting is available only on few charts!!
RE: Dynamically specify Data Colour using column e.g #A66999.
As noted by others not all visuals support conditional formatting. I also think the ask is to be able to do this in the 'fields" view. Drop a column into a Color Values box.
When you have a multi-page report with 4 to 7 Line and stacked column charts per page, it takes significant time to update all of them.
RE: Dynamically specify Data Colour using column e.g #A66999.
Agreed...this can't be considered 'complete' while standard charts like line charts don't currently support this as at Nov 2019. Also, there should be an option to set the color of ALL series directly from the UI, while still allowing us to override on a series-by-series basis as we can in Line charts for line thickness.
RE: Dynamically specify Data Colour using column e.g #A66999.
Hi - I have been testing out this capability, and although it can be applied to some visuals, not all of the built in visuals can be controlled in this way. The visuals that don't have colour control by field are: Stacked Area Chart, Line Chart, Pie Chart, Area Chart, Donut Chart.
I can see all the top line visuals do have this control including the bar and columns charts, but this is not complete.
RE: Dynamically specify Data Colour using column e.g #A66999.
and Fanzil - you can locate a measure in a separate colour dimension table which can be used to map colours onto data values.
RE: Dynamically specify Data Colour using column e.g #A66999.
I agree with Scott M: this is far for being "Completed". The advance formatting is only available for column and bar charts. Moreover the "by Field Value" formatting works only if the Hex color code is located in the same data table of the values displayed and not through a related table, which is very inefficient for big datasets.
RE: Dynamically specify Data Colour using column e.g #A66999.
I only see Conditional Formatting available in Table. I don't think this should be closed until it's available in all appropriate visuals (Bar, Column, Line...)
RE: Dynamically specify Data Colour using column e.g #A66999.
Seems "Advanced controls" in the Data colors is missing in last releases=