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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Super User
Super User

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


@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.