Forum Discussion
ThomasWeppler
1 year agoImpactful 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 o...
- Anonymous1 year ago
ThomasWeppler
Could what i've done here solve it for you? Color kunde rankI'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 _RevenueAnd 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.
Anonymous
1 year agoNot applicable
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.
- ThomasWeppler1 year agoImpactful Individual
hi Anonymous
Thanks for the help. 🙂