Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
Solved! Go to 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
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.
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
182 | |
85 | |
67 | |
61 | |
53 |