In this 4th Power BI Solution Round we find a way to filter the top 3 videos of trending videos on KZitem per quarter. You need to create a DAX measure that enables you to apply a TopN filter on a per category level.
Requirements:
Create a matrix visualisation with:
- Year and quarters on row together with the title field
- Create a measure that returns the total number of views in millions and add it on values.
- Create a measure that assigns a rank to the videos based on the number of views.
- Filter the matrix visualisation on the top 3 per quarter.
Download file here datatraining.i...
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatrainin...
Power BI Essentials datatraining.i...
Business User Training datatraining.i...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.ne...
Newsletter datatraining.i...
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicso...
🚀 For growing on KZitem: www.tubebuddy....
🏄 Stuff I use daily 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 Solution ROUND #4 I How to apply a TOPN FILTER per category in Power BI
No video
Пікірлер: 22