Color scale for a specific visual

[ThomasWeppler]

Hi Power Bi community

Is it possible to make a colorscale that always pick a specific color for the top customer?
I want to make a color scale so my visuals looks good.
I can chance the colors of the induvidual customers, like this.

My problem is that when new customers become the top customer, Power BI might pick a random color that doesn't look good with the rest of my colors.
What should I do to make power BI automatically pick from the colors I have pre defined in a specific visual?

[Anonymous · Accepted solution]

@ThomasWeppler 

Could what i've done here solve it for you? Color kunde rank 

I've created the following table to hold the colors

Used Rank on my X-axis here

Created the following measure:

Kunde Rank sales = 
VAR _SelectedRank = SELECTEDVALUE(RankedCustomers[Rank])
VAR _Table = ADDCOLUMNS(
    SUMMARIZE(
        FactSales,
        FactSales[Kunde]
    ),
    "Total Sales", CALCULATE(SUM(FactSales[Revenue])),
    "Rank", RANKX(
        ALL(FactSales[Kunde]), -- Ensure ranking is global across all customers
        CALCULATE(SUM(FactSales[Revenue])), -- Value to rank by
        ,
        DESC,
        DENSE
    )
)

VAR _Revenue = SUMX(FILTER(_Table, [Rank] = _SelectedRank),[Total Sales])
RETURN 
_Revenue

And the I've setup conditional formatting like this: 

Did I solve your question? Mark my post as a solution! Kudos are appreciated as well as LinkedIn endorsements.

[ThomasWeppler]

hi @Anonymous 

Thanks for the help. 🙂