Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
56 | |
38 | |
34 |
User | Count |
---|---|
99 | |
56 | |
51 | |
44 | |
40 |