No video
Power BI Practice Solution ROUND #4 I How to apply a TOPN FILTER per category in Power BI
Рет қаралды 7,166
Күн бұрынIn this 4th Power BI Solution Round we find a way to filter the top 3 videos of trending videos on KZfaq 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 KZfaq: 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
@HowtoPowerBI 3 жыл бұрын
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
@badoboroten1206 Жыл бұрын
For me, you really are the best "Power BI man" on KZfaq. Thank you for your work, you help me to learn a new useful world quickly and painlessly
@pilarbaldominos2505 3 жыл бұрын
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!
@metecakmak376 2 жыл бұрын
I couldn't figure out why we typed hasonevalue. A brief explanation can be so valuable for me. Thank you for the video!
@Amr-Ibrahim-AI Жыл бұрын
Thanks Bas for sharing and for explaining the steps and logic in details. This helped me.
@cidfidchris 2 жыл бұрын
Hey Bas. Amazing teaching skills!! Thanks for sharing your knowledge
@HowtoPowerBI 2 жыл бұрын
thank you so much Cedrick! that's really nice to hear
@mardithpascua8112 2 жыл бұрын
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..
@nikakalichava8012 Жыл бұрын
Thanks!
@abubakrsaadmakyhoun7535 3 жыл бұрын
big thanks
@HowtoPowerBI 3 жыл бұрын
😀 thanks for watching!
@sharmilalokhande837 6 ай бұрын
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
@jjohn108 2 жыл бұрын
This is Gold :)
@HowtoPowerBI 2 жыл бұрын
thank you!!!! 😀
@Smeetr 2 жыл бұрын
for me the last part of filter is not working if selection is above 5...any idea?
@NunoGomes19 3 жыл бұрын
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 ?
How to Power BI
Рет қаралды 2,4 М.
How to Power BI
Рет қаралды 30 М.
Fernan
Рет қаралды 26 М.
Adam Finer - Learn BI Online
Рет қаралды 98 М.
Continuous Delivery
Рет қаралды 153 М.