Skip to main content
Microsoft Idea

Power BI

Needs Votes

Data colors Conditional formatting for Charts with Legend split

Vote (46) Share
Vasko's profile image

Vasko on 17 Sep 2019 20:33:20

We are missing the Data colors Conditional formatting based on Field value, when a Legend split is used.

Example
Report: CO2 emissions by Country by Year

Requirement: the Color to stick to the Country, since it visually associates the user with the content.
Data colors Conditional formatting for now provides this only when the Country is plotted on the axis as stand alone.


Chart Type: Stacked Column
X axis: Years with Legend split by Country
Y axis, Value: CO2 emissions

Data Points:
[
{"Country":"US", "Color":"#B22234", "Year":2017, "CO2":100},
{"Country":"US", "Color":"#B22234", "Year":2018, "CO2":102},
{"Country":"US", "Color":"#B22234", "Year":2019, "CO2":105},
{"Country":"UK", "Color":"#00247d", "Year":2017, "CO2":30},
{"Country":"UK", "Color":"#00247d", "Year":2018, "CO2":32},
{"Country":"UK", "Color":"#00247d", "Year":2019, "CO2":35},
{"Country":"China", "Color":"#DE2910", "Year":2017, "CO2":130},
{"Country":"China", "Color":"#DE2910", "Year":2018, "CO2":132},
{"Country":"China", "Color":"#DE2910", "Year":2019, "CO2":135},
]

Using the with Country split in Legend disables the Data colors Conditional formatting.

Comments (2)
Vasko's profile image Profile Picture

M K on 16 Dec 2022 19:03:59

RE: Data colors Conditional formatting for Charts with Legend split

This would be great to have. Right now colours of the dimensions keep changing over time and apparently even differs for different users

Vasko's profile image Profile Picture

Alex Miller on 06 Jul 2020 00:14:35

RE: Data colors Conditional formatting for Charts with Legend split

This is exactly the post I was looking for and took me a while to figure out that the Legend was preventing me from selecting the color. This would be a very useful feature.