Power BI Practice Intro ROUND #7 I Apply CONDITIONAL FORMATTING for each individual row in a table

Custom conditional formatting for each individual row can be tricky. In this Power BI Practice Round you need highlight the highest and lowest prices row by row for each city. The dataset contains the price development for different foods over time for different countries.

Requirements:
- Create a matrix table that shows the average price per month and year (on columns) and country (on rows)
- Add slicers for country and commodity
- Choose the country Armenia, commodity carrots, and year 2016 as a filter
- Write a dax measure that returns red when the price equals the highest price for that country and green when it equals the lowest price
- Duplicate the page and remove the filter on year for that page
- Add another measure that does the same as the measure before, however checks each price vs highest and lowest price for a certain country AND year

Share your approach, questions, feedback below or on Twitter using the hashtag #PowerBIPractice and tag @HowToPowerBI

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[haboos]

here is my measure :

Color = var maxv = CALCULATE(MAX(food_prices[Price]), ALLEXCEPT(food_prices, food_prices[Country], food_prices[City], food_prices[Commodity], dimDate[Year]))
var minv = CALCULATE(MIN(food_prices[Price]), ALLEXCEPT(food_prices, food_prices[Country], food_prices[City], food_prices[Commodity], dimDate[Year]))
var selected=
var color=if(selected=minv, "Green", IF(selected=maxv, "Red"))
return color

i think i have over complicated it, so please advise :D

[haboos]

Nice challenge, i thought it was easy, but its not that easy :S

can i share my DAX script here?