Forum Discussion
Static Color in Stacked Column Chart Based on Rank
Hello Power BI Community, I’m working on a stacked column chart and facing a challenge with the color scheme. My goal is to assign static colors to the top three products based on their rank, rather...
Hi, To assign static colors to the top three products based on rank in a stacked column chart, you can create a calculated column to determine the rank and then use conditional formatting.
- Create a Rank Column:
ProductRank = RANKX(ALL(Table[Product]), Table[Sales], , DESC, DENSE)
- Use Conditional Formatting:
Go to the Data Colors section in the Visualizations pane, and set rules based on the ‘ProductRank’ column. Assign specific colors to ranks 1, 2, and 3.
This approach ensures that the top three products always have consistent colors.
Hi chiru_kudupudi,
Unfortunately, this won't solve the problem because there is no option for conditional formatting in stacked columns charts.
