Applying custom conditional formatting for each individual row in a table can be tricky. In this Power BI Practice Round we 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 [ Ссылка ]
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program [ Ссылка ]
Power BI Essentials [ Ссылка ]
Business User Training [ Ссылка ]
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
😍 JOIN 😍
----------------------------------
Join [ Ссылка ]
Subscribe [ Ссылка ]
Insta [ Ссылка ]
LinkedIn [ Ссылка ]
TikTok [ Ссылка ]
X [ Ссылка ]
fb [ Ссылка ]
Threads [ Ссылка ]
Newsletter [ Ссылка ]
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear [ Ссылка ]
📚 Power BI books MUST READ! [ Ссылка ]
💡 General books I recommend [ Ссылка ]
🎶 Music for my videos [ Ссылка ]
🚀 For growing on YouTube: [ Ссылка ]
🏄 Stuff I use daily [ Ссылка ]
* 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
