Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Impactful Individual
1 year ago
Solved

Color scale for a specific visual

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?

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.