Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Contributor

## Gradient color in pivot table

Hello Community,

sorry for this basic question, but I have checked several other Community posts and videos and can't solve it.

I have a Pivot table and want to fill in a background color gradient to get this:

I already created the same matrix, only the colours are missing.

How can I add them? (light green to dark green)

Please find attached the App, i already tried it with a measure but it doesn't work.

Really appreciate your help.

Best LoK

Labels (2)
• ### Color background in pivot table

3 Replies
You have to write background color for each color code combination
something like
if(Count(distinct[OrderNumber])>0 and Count(distinct[OrderNumber])<100, RGB(100,10,10),RGB(255,12,120))

Regards,
Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended.
Partner - Master

Hi LoK,

Use this formula and paste in the ARGB codes your own codes:

``````ColorMix1 ((1+Sign(2*(Count(distinct[OrderNumber])-RangeMin (top(total
Count(distinct[OrderNumber]),1,NoOfRows(total))))/(RangeMax (top(total
Count(distinct[OrderNumber]),1,NoOfRows(total)))-RangeMin (top(total
Count(distinct[OrderNumber]),1,NoOfRows(total))))-1)*Sqrt(Fabs((2*
(Count(distinct[OrderNumber])-RangeMin (top(total
Count(distinct[OrderNumber]),1,NoOfRows(total))))/(RangeMax (top(total
Count(distinct[OrderNumber]),1,NoOfRows(total)))-RangeMin (top(total
Count(distinct[OrderNumber]),1,NoOfRows(total))))-1))))/2, ARGB(255, 0, 215, 0), ARGB(255, 0, 128, 0))``````

You can fill it in now, but the numbers are a little bit skewed so that gives a bit wrong colors.

Jordy

Climber

Work smarter, not harder

attaching sample qvf.

Great dreamer's dreams never fulfilled, they are always transcended.
Tags
Community Browser