The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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)
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
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
Product | Amarilla | #9b9b7a |
Product | Carretera | #797d62 |
Product | Montana | #d08c60 |
Product | Paseo | #d9ae94 |
Product | Velo | #f1dca7 |
Product | VTT | #ffcb69 |
Product | #997b66 |
There are many products in the finacials table to one color in the Colors table
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