Just pasting the reply someone has posted in other comments "You need to insert the Top Value Values into the filter and change the criteria to Is Not Blank. That way, the thing will filter through and have a dynamic total"
@@HealingHooman4616 This doesn't seem to work either. Tried with the 'Top Values'[Top Values] and the [Top Values Value]. It does not change the table total for me.
Hi @Solutions Abroad, I like this tutorial. But, If you absorb Total of Top 5 and total of Top 10 are same, they're not changing. How to get the total as well, as per for TopN?
Thank your video's. Always very clear when explaining. I have one question. I tried using the parameter for the ranking in my dashboard. When I place the rank on 5 for example, I only get 4 results in my table. What can I do to fix this? Or what am I doing wrong.
After applying If conations the rows are not being filtered. i am able to see all the countries with the blank values & the TOP N values with the sales values
Hi..The total amt in the table is not reflecting correctly. Eg. For Top 5 countries, the total Sales should be 848,171.48. However, as per the table, it shows 13,54458.59. How to correct this? ,
You need to insert the Top Value Values into the filter and change the criteria to Is Not Blank. That way, the thing will filter through and have a dynamic total
Hi thanks! What if a want to see the top 10 Products but also have a column named region to see from which region they are, but not giving me top 10 for each one?
Hi there, depends on how you want to show your data on your card, because card needs to show summarised values. You can look at using multi row cards which should work
@@SolutionsAbroad thanks for your reply! :) I’d like to ahow the totals of the totals of the top N E.g the total sales of top 5, if i change value of N to top 3 the card will change to total sales of top 3
@@SolutionsAbroad This is not working with Multi Rows Card as well. Can you please let me know the way to show this in card visual? Card Visual is working fine for TOPN function.
Perfect! however I tried to add another column in legend and it didn't work, so to use your example I wanted to show Countries, categories and use the rankx over that
Thanks for watching! It sounds like you need to use conditional formatting to highlight your bar chart values! I covered it in a separate video if you're interested
@@MLissieMusic Here you go! th-cam.com/video/p88TaEX8H0E/w-d-xo.html Just note that it's one piece of the puzzle so you'll need to think about how to integrate this with your drilldowns, hope that helps!
that's great! thanks for the videos. Please i have a question: when i do that for top and bottom, it seems to rank well, I actually set so that it will just rank those category with have a value , however there are some that are empty, and so the ranking works fine for top but then bottom will only display the range i selected minus 1, meaning that i select Bottom with a range of 3, so Bottom 3 categories, it shows me all categories that rank 1 and 2 but not 3 even is correctly ranked, and is not ranking the categories that have no values. Any suggestions? the top 3 categories display fine but not when i select bottom. the formula is the same except for the ASC and DESC part
You cant imagine how your videos have helped me in my current job, you are a lifesaver! Thank you, keep up with the good content!🎉
One can find so many videos related to dynamic top n, but this one is the best till date on the internet
Thanks!
Thanks for the generosity Randy, appreciate it!
This was amazing. Thank you very much for making this tutorial.
I was looking for that content for a long time! Thank you!
Right on the spot what i was looking for.
Fernan,
Great video as always, In this video, I noticed that the Total for the top N is the same as the total for the entire table
top N and by different categories. can we do that as well? say two parameters, one is top N , another one is by country, by product, by entity etc.
This tutorial helped me a lot.
Thanks for making this. Good Explanation
Very Interesting Demo !!!
Very good work but when you change the parameter, the total does not change, how to fix it?
Just pasting the reply someone has posted in other comments "You need to insert the Top Value Values into the filter and change the criteria to Is Not Blank. That way, the thing will filter through and have a dynamic total"
@@HealingHooman4616 This doesn't seem to work either. Tried with the 'Top Values'[Top Values] and the [Top Values Value]. It does not change the table total for me.
Fantastic! 🎉🎆 Always love your videos! Always to the point, useful ones and very informative!
Hi @Solutions Abroad, I like this tutorial. But, If you absorb Total of Top 5 and total of Top 10 are same, they're not changing.
How to get the total as well, as per for TopN?
Solved alot Questions. Great to learn from you.
Hi
I have an issue. The rakink and top issue are working as expected, But when Months in columns I get some blanks totals how to I filter it out
Thank your video's. Always very clear when explaining. I have one question. I tried using the parameter for the ranking in my dashboard. When I place the rank on 5 for example, I only get 4 results in my table. What can I do to fix this? Or what am I doing wrong.
After applying If conations the rows are not being filtered. i am able to see all the countries with the blank values & the TOP N values with the sales values
Hi..The total amt in the table is not reflecting correctly. Eg. For Top 5 countries, the total Sales should be 848,171.48. However, as per the table, it shows 13,54458.59. How to correct this? ,
You need to insert the Top Value Values into the filter and change the criteria to Is Not Blank. That way, the thing will filter through and have a dynamic total
@@KhaiNguyen-yh9mt Genius :)
@@HealingHooman4616 did that work for you? It did NOT work for me.
Thank you so much for helping me understand this procedure ^^...
Hi thanks! What if a want to see the top 10 Products but also have a column named region to see from which region they are, but not giving me top 10 for each one?
Very insightful
How can you make this work with a Card visualization?
Tried, and the Card always provides the total regardless of N selected
Hi there, depends on how you want to show your data on your card, because card needs to show summarised values. You can look at using multi row cards which should work
@@SolutionsAbroad thanks for your reply! :)
I’d like to ahow the totals of the totals of the top N
E.g the total sales of top 5, if i change value of N to top 3 the card will change to total sales of top 3
@@Mikel526 Did you get the solution for this? This is not working with Multi Rows Card as well.
@@SolutionsAbroad This is not working with Multi Rows Card as well. Can you please let me know the way to show this in card visual?
Card Visual is working fine for TOPN function.
Thank you so much!
Perfect! however I tried to add another column in legend and it didn't work, so to use your example I wanted to show Countries, categories and use the rankx over that
Very good stuff mate
That was great mate. I do have a question. How can I change the labels and color of a graph 📊 as I drill down into it?
Thanks for watching! It sounds like you need to use conditional formatting to highlight your bar chart values! I covered it in a separate video if you're interested
@@SolutionsAbroad great to hear. It would be good to know the link or title of the video mate.
@@MLissieMusic Here you go! th-cam.com/video/p88TaEX8H0E/w-d-xo.html Just note that it's one piece of the puzzle so you'll need to think about how to integrate this with your drilldowns, hope that helps!
there is issue here that the total of table is not changed
that's great! thanks for the videos. Please i have a question: when i do that for top and bottom, it seems to rank well, I actually set so that it will just rank those category with have a value , however there are some that are empty, and so the ranking works fine for top but then bottom will only display the range i selected minus 1, meaning that i select Bottom with a range of 3, so Bottom 3 categories, it shows me all categories that rank 1 and 2 but not 3 even is correctly ranked, and is not ranking the categories that have no values. Any suggestions? the top 3 categories display fine but not when i select bottom. the formula is the same except for the ASC and DESC part
The total doesn't change with the parameter value. How can I change that?
amazinng explanation!
How to make selected topn in lageest to smalest..because in your list rank not applied based on sales value
Does this Parameter changes value in other visualizations too?
the total is not dynamic
Awesome!!
Awesome content.
Thanks❤
great work
Hi, Bought silver membership, still not able to download demo files of this video. Please fix it soon
The sum of Total values of topn are wrong, how can I fix?
Hi, I tried the same dax formula but not working, every row shows rank 1.
What to do to have correct sum of top selected in the table?
Great video but doesn’t work in my case 😢. Rank does not rank my values.
Hi is there someone who can help with ranking sales by month?