Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
ronnoc
Advocate II
Advocate II

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.

 

chart 1.PNG

 

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

 

chart 2.PNG

 

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.

 

hex colors.PNG

 

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

 

datacol.PNG

 

 

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.

2 ACCEPTED SOLUTIONS
KHorseman
Community Champion
Community Champion

Sounds like a good thing to suggest in the Ideas forum.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
KHorseman
Community Champion
Community Champion

Sounds like a good thing to suggest in the Ideas forum.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Made a suggestion. When creating multiple reports at the same time this should be much more efficient. 

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17007328-set-data-colors-programm...

Greg_Deckler
Community Champion
Community Champion

I am not aware of a way to do what you are looking for, would make a great Idea though if something similar is not already out there. https://support.powerbi.com/forums/265200-power-bi



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.