need help

[anithaMallam]

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

[amitchandak]

@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]

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]

Hi  @anithaMallam ,

Have you checked my reply?

Best Regards,
Kelly

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

[v-kelly-msft]

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!