Power BI Practice Solution ROUND #2 I MEASURES vs CALCULATED COLUMNS and CUSTOM TOOLTIPS in Power BI
In this second Power BI Practice Round we are assessing to what extent a company is dependent on just one single supplier for its products. We solve this challenge in two ways - one time using measures and the second time with a calculated columns and custom tooltips in Power BI.
Requirements:
Key Visuals:
- Create a measure that returns the number of Vendors per product.
- Create one measure that calculates the number of products with 1 Vendor.
- Add another measure that calculates the number of products with more than 1 Vendor.
- Show it share 1 Vendor vs more than 1 Vendor on a donut chart.
- Try to get to a similar visualisation but now by adding a calculated column. The calculated column should calculated the number of vendors for each product and either return more than 1 Vendor or 1 Vendor.
- Show it share 1 Vendor vs more than 1 Vendor on a donut chart.
Download file here https://datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powe...
Power BI Essentials https://datatraining.io/powerbilearni...
Business User Training https://datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly [email protected]
---------------------------------
😍 JOIN 😍
----------------------------------
Join https://bit.ly/4b453bi
Subscribe https://bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / 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/referra...
🚀 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