Forum Discussion

anithaMallam's avatar
anithaMallam
Helper III
5 years ago

need help

Hi All,

          Need your help on the below requirement.

i am creating a matrix as shown below

 

now i need to do conditional formating for the % columns as if the gross sales,volume<1% it should be green and for the cost values if the % difference is <3% it  should be green.in the same matrix these conditions needs to be applied.could some please help me in implementing the conditional formatting.

 

Regards

Anitha

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    anithaMallam , conditions are not clear. But if they measure based on priority you can create a color measure

     

    Switch(true() ,

    [Volume] <.01 , "green",

    [Difference] <.03 , "green"

    //other condition

    "red"

    )

     

    combine conditions if needed

     

    How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

    • anithaMallam's avatar
      anithaMallam
      Helper III
      5 years ago

      Hi Amit,

                   

      the last 3 columns needs to be conditionally formatted if Gross sales and volume <1% and material cost and resource cost <3%.

       

      Regards

      Anitha

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi  anithaMallam ,

         

        Could you pls provide a sample .pbix file or sample data for test?

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my reply as a solution!