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 c...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    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

  • TomMartens's avatar
    TomMartens
    8 years ago

    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

     

MFelix's avatar
MFelix
Super User
8 years ago

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
    8 years ago

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

    • TomMartens's avatar
      TomMartens
      Super User
      8 years ago

      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's avatar
        rocky777
        Frequent Visitor
        8 years ago

        Many thanks for your help!!!