Forum Discussion

amirabedhiafi's avatar
amirabedhiafi
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Find a design for the matrix

How can I create this design for a matrix ? :

 

  • Hi amirabedhiafi 

     

    You can find the databar formating option here. Please make sure that you have your values formatted as numbers or percentage upfront. Otherwise it will not appear.

    Then make the configurations as you need.

    Please use as a visual a matrix with the following configurations.

     

    Best regards 

    Mikelytics

     

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

     

    Did I answer your questions? Please mark my post as solution.

     

    Appreciate your Kudos.

     

4 Replies

  • Mikelytics's avatar
    Mikelytics
    Icon for Resident Rockstar rankResident Rockstar

    Hi amirabedhiafi 

     

    You can find the databar formating option here. Please make sure that you have your values formatted as numbers or percentage upfront. Otherwise it will not appear.

    Then make the configurations as you need.

    Please use as a visual a matrix with the following configurations.

     

    Best regards 

    Mikelytics

     

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

     

    Did I answer your questions? Please mark my post as solution.

     

    Appreciate your Kudos.

     

    • amirabedhiafi's avatar
      amirabedhiafi
      Icon for Impactful Individual rankImpactful Individual

      and if I want to have a specific databar formating for each column of my matrix what should I do ?

      • Mikelytics's avatar
        Mikelytics
        Icon for Resident Rockstar rankResident Rockstar

        Hi amirabedhiafi,

         

        looking on my pictures you can see that I execute the steps for one specific column / value . So you can execute this steps several times for each value individually.

         

        Best regards

        Mikelytics

         

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

         

        Did I answer your questions? Please mark my post as solution.

         

        Appreciate your Kudos.

         

  • VijayP's avatar
    VijayP
    Icon for Community Champion rankCommunity Champion

    amirabedhiafi  You can use Databars for the Values in Conditional formatting! and For headings you can create a Text box or Shape with Text box. Try and let me know! 

    Please share your Kudos and if this satisfies your requirement please mark this as solution

    Vijay Perepa