Hi @JPINE,
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.
