Power BI Practice Solution ROUND #4 I How to apply a TOPN FILTER per category in Power BI

[@HowtoPowerBI]

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

[@databoom5905]

Transpose for complex data

[@aykoshaa92]

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 KZbin. Thank you for your work, you help me to learn a new useful world quickly and painlessly

[@ankittripathi8305]

very informative, I used these features in three visuals, to toggle TOPN values through one slider. thank you BAS

[@pilarbaldominos2505]

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]

Great to hear! and thanks for subscribing!

[@metecakmakk]

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]

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

[@HowtoPowerBI]

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

[@sharmilalokhande837]

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

[@Smeetr]

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

[@NunoGomes19]

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]

Happy to have a look. Could you send me a sample [e-mail] ?

[@nikakalichava8012]

Thanks!

[@mardithpascua8112]

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]

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

[@abubakrsaadmakyhoun7535]

big thanks

[@HowtoPowerBI]

😀 thanks for watching!

[@johnj108]

This is Gold :)

[@HowtoPowerBI]

thank you!!!! 😀