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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors