Forum Discussion

Mabelle's avatar
Mabelle
New Member
10 years ago

Assign color automatically in line chart

Hi, I have a line chart with about 250 lines. This is very messy but normally a filter is used to display at most 10 lines. All lines have different colors. But I would like to assign always the sa...
Need Help
Tips and Tricks
Brian_M's avatar
Brian_M
Icon for Continued Contributor rankContinued Contributor
10 years ago

Hi Mabelle,

 

I have asked for this type of functionality here, where by you could define a column or measure in your model that would output a colour reference.

 

You could for example define a table with ten colours, e.g. Color 1 (e.g. #FF0000 = red) to Color 10 (#0000FF = blue) and then match this list of ten colours to your list of top ten items.

 

If you think this might help you out, please vote for the idea here and leave a comment letting MS know what your application / situation might be.

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13757925-dynamically-specify-data-colour-using-column-e-g

 

Hope that helps