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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

I need to have each data point the same color regardless of how it is shown.

I need to have each data point have the same color across every  instance.

IE:  When "Alaska" has data in a report it needs to be purple.  And "California"data needs to be green.

I know how to set that manually, but I was hoping that there would be a easy way to set up a way to set it up for the entire dashboard.  Set it up across tabs. Hopefully even set it up as a template for future dashboards.

Thanks

 

The version I am using: 2.114.664.0 64-bit (Febuary 2023)

 

 

2 REPLIES 2
ppm1
Solution Sage
Solution Sage

You can add a table to your model with a column for each value along with a column with the hexcode (or RGB) for each one. You can relate it on your value column and use a simple measure to get the SELECTEDVALUE of the color to be used in each visual.

 

Pat

Microsoft Employee
Anonymous
Not applicable

TY for your input.  I have the table set up , but am running into issues with how to implement it.

I do not understand "You can relate it on your value column and use a simple measure to get the SELECTEDVALUE of the color to be used

in each visual."

Here is my table

Type            Full Name     HexColor

ProductAmarilla#9b9b7a
ProductCarretera#797d62
ProductMontana#d08c60
ProductPaseo#d9ae94
ProductVelo#f1dca7
ProductVTT#ffcb69
Product #997b66

 

There are many products in the finacials table to one color in the Colors table

christinewineyv_1-1682702756744.png

 

The only cardinality that the app let me create is a many to many, but that is not correct.

I manually create a bar chart.  

Now where do I set those colors?  

Do you mean to say I write code that pulls them into the chart?

Thanks

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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