Power BI Practice Solution ROUND #4 I How to apply a TOPN FILTER per category in Power BI
Ғылым және технология
In this 4th Power BI Solution Round we find a way to filter the top 3 videos of trending videos on KZread 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.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
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.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 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.epidemicsound.com/referra...
🚀 For growing on KZread: www.tubebuddy.com/bas
🏄 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
Пікірлер: 22
What would you like to see as a next challenge topic?
@databoom5905
3 жыл бұрын
Transpose for complex data
@aykoshaa92
3 жыл бұрын
Conditional formatting
@marcoloeza9779
Жыл бұрын
Could you rank also the category? The intention is ranking by category and after that rank by subcategory. Btw you're amazing dude
For me, you really are the best "Power BI man" on KZread. Thank you for your work, you help me to learn a new useful world quickly and painlessly
The last piece has help to solve how to create a filter in numeric multiple columns that I couldn't figure out! Thanks for the inspiration... You have a new follower!
@HowtoPowerBI
3 жыл бұрын
Great to hear! and thanks for subscribing!
Thanks Bas for sharing and for explaining the steps and logic in details. This helped me.
I couldn't figure out why we typed hasonevalue. A brief explanation can be so valuable for me. Thank you for the video!
Thanks!
Hey Bas. Amazing teaching skills!! Thanks for sharing your knowledge
@HowtoPowerBI
2 жыл бұрын
thank you so much Cedrick! that's really nice to hear
big thanks
@HowtoPowerBI
3 жыл бұрын
😀 thanks for watching!
This is Gold :)
@HowtoPowerBI
2 жыл бұрын
thank you!!!! 😀
i tried this and no problem except for a rows with same values, I have 15K, 15K, 20K, 21K and the ranking was 1, 1, 3, 4
@haribharadwaj1
2 жыл бұрын
That's behaving as it should isn't it? what other context does the engine have to discriminate between the two 15s ? .. Also I think your sort order is incorrect..
Hey Bas, I have one query, is it possible to display the details in another table visual when you click on any title. For example when you click on any title , details like viewer name , date etc should be display to another table visual. Thanks
What if I only to to show the top 1 Main Catergory? (in this video the Top Quarter). I've tried this on one of my datasets and I created a rank measure for my main category. If I put both rank measure on a matrix table, without any filter the output is correct for both of them, showing 1,2,3... where is suposed to be. But then, If I put the rank measure for the sub-categories on filters to only show the Top 5, the rank measure for the main category starts behaving incorrectly the the outputs change to only 1 and 2 (repetead on a bunch of main categories). Any ideia why this happens? Thanks
@HowtoPowerBI
3 жыл бұрын
Happy to have a look. Could you send me a sample bas.dohmen@datatraining.io ?
for me the last part of filter is not working if selection is above 5...any idea?