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"
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?
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
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
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?
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
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.
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
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.
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! ua-cam.com/video/p88TaEX8H0E/v-deo.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!
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
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.
the total is not dynamic
This tutorial helped me a lot.
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.
Thanks for making this. Good Explanation
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"
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
Very Interesting Demo !!!
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.
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
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
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
Thank you so much for helping me understand this procedure ^^...
Fantastic! 🎉🎆 Always love your videos! Always to the point, useful ones and very informative!
there is issue here that the total of table is not changed
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?
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
Thank you so much!
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.
The total doesn't change with the parameter value. How can I change that?
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 :)
Very good stuff mate
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.
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! ua-cam.com/video/p88TaEX8H0E/v-deo.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!
Awesome content.
amazinng explanation!
Awesome!!
Does this Parameter changes value in other visualizations too?
Thanks!
Thanks for the generosity Randy, appreciate it!
The sum of Total values of topn are wrong, how can I fix?
great work
Thanks❤
Hi, Bought silver membership, still not able to download demo files of this video. Please fix it soon
Great video but doesn’t work in my case 😢. Rank does not rank my values.
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?
Hi is there someone who can help with ranking sales by month?