Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ThomasWeppler
Impactful Individual
Impactful Individual

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.

ThomasWeppler_0-1732871725668.png

 

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?

1 ACCEPTED SOLUTION
KriZo
Resolver II
Resolver II

@ThomasWeppler 

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

 

I've created the following table to hold the colors

KriZo_0-1732873002335.png

 

Used Rank on my X-axis here

KriZo_1-1732873031763.png

 

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: 

KriZo_2-1732873125398.png

 

 

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

 

174857.png

View solution in original post

2 REPLIES 2
KriZo
Resolver II
Resolver II

@ThomasWeppler 

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

 

I've created the following table to hold the colors

KriZo_0-1732873002335.png

 

Used Rank on my X-axis here

KriZo_1-1732873031763.png

 

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: 

KriZo_2-1732873125398.png

 

 

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

 

174857.png

ThomasWeppler
Impactful Individual
Impactful Individual

hi @KriZo 

Thanks for the help. 🙂

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.