topic Dynamically Change Colors in Power BI for Different Product Names in DAX Commands and Tips

Dynamically Change Colors in Power BI for Different Product Names

Anonymous — Mon, 14 Apr 2025 16:30:59 GMT

I have a a table containing a Product Name column with many different product names that can be somewhat long (several words) and new product names are being added all of the time. Is there a way to not only add different colors to the current product names but automatically color any new product names that are added (without having to add the additional procuct and name in an expression)? Once this is accompished, I want to color code the entire row (that has related information about that product) the same color as the product name.

Thank you for any suggestions, as I am very new to this.

Re: Dynamically Change Colors in Power BI for Different Product Names

lbendlin — Mon, 14 Apr 2025 17:14:16 GMT

but automatically color any new product names

What's your definition of "new" ? Power BI has no memory, so you need to provided a hint.

Re: Dynamically Change Colors in Power BI for Different Product Names

v-saisrao-msft — Thu, 17 Apr 2025 10:52:08 GMT

Hi Anonymous,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Thank you lbendlin, for your insights.

To automate the color coding of product names in Power BI, including for new products, you can follow these steps to apply dynamic and consistent color formatting without manually updating each new product.

Create a measure in Power BI to automatically assign a unique color to each product name. This should use a method that ensures each product name consistently gets a specific color, even when new products are added. Consider using a hash function or similar logic to map each product name to a color automatically. The goal is to define this mapping in a way that doesn't require manual updates as new products are introduced.
Once you have set up the dynamic color measure, you can apply it to the "Product Name" column using Power BI’s Conditional Formatting feature. This will automatically color-code the product names based on your defined logic, ensuring consistency.
To ensure the entire row containing product information is color-coded, apply the same color measure to other columns in your table visual. By setting conditional formatting for each additional column to match the color measure, the entire row will adopt the same color as the product name, creating a cohesive visual display.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

Re: Dynamically Change Colors in Power BI for Different Product Names

v-saisrao-msft — Mon, 21 Apr 2025 04:23:22 GMT

Hi Anonymous,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

Re: Dynamically Change Colors in Power BI for Different Product Names

v-saisrao-msft — Thu, 24 Apr 2025 06:40:02 GMT

Hi Anonymous,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: Dynamically Change Colors in Power BI for Different Product Names

v-saisrao-msft — Mon, 28 Apr 2025 10:18:55 GMT

Hi Anonymous,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.