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 o...
  • 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.