2 Gradient colors in 1 table (matrix)

[rocky777]

Hi! I have a table with negative and positive numbers. Depend on the pressed slicer there are 3 types of data: Only positive numbers, only negative numbers and mixed numbers.

 

You can notice that there is only 1 gradient: from orange (min) to blue (max).

What i need:

Positive numbers- ---> gradient color from light blue to dark blue

Negative numbers ---> gradient color from light orange to dark orange

Is there any way to do that?

-------------------------------------------------

And 1 more question. Is there any visuals to introduce my data like the pic. below

I can see only 1 variant with 3 different visuals filtered by a certain year (pic below)

[MFelix · Accepted solution]

Hi @rocky777,

Did you try to make the use of the conditional formattin with the diverging colour but placing the 0 in the middle:

Regards

MFelix

[MFelix · Accepted solution]

Hi @rocky777,

Did you try to make the use of the conditional formattin with the diverging colour but placing the 0 in the middle:

Regards

MFelix

[rocky777]

Thank you for the answer!!! Any suggestions about the second question?

[TomMartens · Accepted solution]

Hey,

regarding your second question, give the custom visual "Infographic Designer" a try. You will find it in the marketplace (it's a free visual developed by Microsoft).

This chart

was created by using this settings:

Hope this is what you are looking for.

Regards

Tom

[rocky777]

Many thanks for your help!!!