Forum Discussion

ronnoc's avatar
ronnoc
Advocate II
9 years ago
Solved

Set data colors programmatically in power desktop

I have multiple bar charts which use common fields in the data set. Is it possible to set a default for the data colors of these fields so that whenever 'television' (for example) as a digital media type appears in any chart or visualisation it is always the same data color??

 

This chart has been set to the correct colors set.

 

 

This is another chart with the common field of 'media type' which defaults to a color scheme provided by powerBI.

 

 

I have all my hex codes stored in a table and I am wondering is there any way to have the charts among all pages of the report to pull these codes programmatically so that all charts default to my preferred color set.

 

 

without needing to be manually set here on each instance of a chart which is very time consuming:

 

 

 

So far responses on this forum have been prompt and very useful so thank you for all your help so far. 

 

Any input is appreciated.

4 Replies