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

  • @HowtoPowerBI
    @HowtoPowerBI3 жыл бұрын

    What would you like to see as a next challenge topic?

  • @databoom5905

    @databoom5905

    3 жыл бұрын

    Transpose for complex data

  • @aykoshaa92

    @aykoshaa92

    3 жыл бұрын

    Conditional formatting

  • @marcoloeza9779

    @marcoloeza9779

    Жыл бұрын

    Could you rank also the category? The intention is ranking by category and after that rank by subcategory. Btw you're amazing dude

  • @badoboroten1206
    @badoboroten1206 Жыл бұрын

    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

  • @pilarbaldominos2505
    @pilarbaldominos25053 жыл бұрын

    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

    @HowtoPowerBI

    3 жыл бұрын

    Great to hear! and thanks for subscribing!

  • @Amr-Ibrahim-AI
    @Amr-Ibrahim-AI Жыл бұрын

    Thanks Bas for sharing and for explaining the steps and logic in details. This helped me.

  • @metecakmak376
    @metecakmak3762 жыл бұрын

    I couldn't figure out why we typed hasonevalue. A brief explanation can be so valuable for me. Thank you for the video!

  • @nikakalichava8012
    @nikakalichava8012 Жыл бұрын

    Thanks!

  • @cidfidchris
    @cidfidchris2 жыл бұрын

    Hey Bas. Amazing teaching skills!! Thanks for sharing your knowledge

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    thank you so much Cedrick! that's really nice to hear

  • @abubakrsaadmakyhoun7535
    @abubakrsaadmakyhoun75353 жыл бұрын

    big thanks

  • @HowtoPowerBI

    @HowtoPowerBI

    3 жыл бұрын

    😀 thanks for watching!

  • @jjohn108
    @jjohn1082 жыл бұрын

    This is Gold :)

  • @HowtoPowerBI

    @HowtoPowerBI

    2 жыл бұрын

    thank you!!!! 😀

  • @mardithpascua8112
    @mardithpascua81122 жыл бұрын

    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

    @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..

  • @sharmilalokhande837
    @sharmilalokhande8375 ай бұрын

    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

  • @NunoGomes19
    @NunoGomes193 жыл бұрын

    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

    @HowtoPowerBI

    3 жыл бұрын

    Happy to have a look. Could you send me a sample bas.dohmen@datatraining.io ?

  • @Smeetr
    @Smeetr2 жыл бұрын

    for me the last part of filter is not working if selection is above 5...any idea?

Келесі