Want to apply Conditional Formatting on Matrix Visual

Hi ManasRout ,

Thank you for the update.

Hi JaywantThank you for providing this solution the value column contain different types of value so I have applied dynamic formatting to bring a single format but after following your steps it applied for all values like %types as well as Non %types I want only apply on %types of value also it coming all are light red still not working. Please let me know If I need to share anything else for better understanding my requirement. 

Hi Danextian, Thank for providing this solution It is not working I am sharing my demo dataset in here since I don't have access to share outside from my laptop along with pbix image since it is not allowing me. In this I am using a matrix visual with under rows I am using 3columns (Section, Funnel, KPI), under columns I am using 3columns(country, retailerid, month_year) under values I am using summarize by sum(Sheet[Value]) and make it dynamic measure using below code.

SWITCH(
 SELECTEDVALUE(Sheet1[KPI]),
 "No. of hero skus", "0",
 "Listing Share", "0" & """%""",
 "Availability (Hero SKU)", "0" & """%""",
 "Content Execution on PDP", "0" & """%""",
 "Rating And Reviews", "0" & """%""",
 "In search", "0" & """%""",
 "On category page", "0" & """%""",
 "Impression Share (only for specific formats).", "0" & """%""",
 "Revenue (EUR)", "#,.00k",
 "Spent (EUR)", "#,.00k",
"ROAS", "0.00"
 )
I am also using 3page level filter (category_name(need to select 1value - Laptop), country(I kept only 1value - india), report_period - 202512). So I want to calculate month over sales for only %types of value if my current month value greater previous then light green else red if same no change based on different retailer_id. I shared sample dataset