Forum Discussion

rocky777's avatar
rocky777
Frequent Visitor
8 years ago
Solved

2 Gradient colors in 1 table (matrix)

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)

  • 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

  • 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

     

4 Replies

  • 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's avatar
      rocky777
      Frequent Visitor

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

      • TomMartens's avatar
        TomMartens
        Icon for Super User rankSuper User

        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