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
Download file here https://datatraining.io/powerbi-how-to

--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation

Power BI Essentials https://datatraining.io/powerbilearningpath

Business User Training https://datatraining.io/powerbi-business-users

For Custom Trainings and Consulting email directly support@datatraining.io

---------------------------------
😍 JOIN 😍
----------------------------------
Join https://bit.ly/4b453bi
Subscribe https://bit.ly/31MnQGO​
Insta https://www.instagram.com/howtopowerbi/
LinkedIn https://www.linkedin.com/in/basdohmen/
TikTok https://www.tiktok.com/@how.to.power.bi
X https://twitter.com/HowToPowerBI
fb https://www.facebook.com/groups/howtopowerbi
Threads https://www.threads.net/@howtopowerbi
Newsletter https://datatraining.io/newsletter

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear https://amzn.to/47F21Yc
📚 Power BI books MUST READ! https://amzn.to/3tUfFcj
💡 General books I recommend https://amzn.to/48YNo33
🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj
🚀 For growing on YouTube: https://www.tubebuddy.com/bas
🏄 Stuff I use daily https://amzn.to/3HqfMQ2

* 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

Видео Power BI Practice Intro ROUND #7 I Apply CONDITIONAL FORMATTING for each individual row in a table канала How to Power BI