Display Different Top n from a Slicer - EASY Trick Works in Excel or Power BI - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Sumit
Thank you Mynda! This is a great example to use measures. It would be great if you can you please confirm a way to see the Top N subcategories by adding one (or more slicer). eg. If I want to show Top N subcategories (here it is disconnected model) and also have another slicer to select Main Category (which may be connected model) to see the top N subcategories within the main category rather than complete data.
reply
Thank you Mynda! This is a great example to use measures. It would be great if you can you please confirm a way to see the Top N subcategories by adding one (or more slicer). eg. If I want to show Top N subcategories (here it is disconnected model) and also have another slicer to select Main Category (which may be connected model) to see the top N subcategories within the main category rather than complete data.
reply
Perry
Hi Mynda, I feel like I have turned a corner watching this, thanks so much! What I am now trying to understand is if it is possible to have an additional Top N series within one pivot table. For example, I want to be able to have 2 slicers in one pivot table as follows 1. The number of cars sold to a customer 2. The value of cars sold to a customer and be able to click in-between these.
reply
Hi Mynda, I feel like I have turned a corner watching this, thanks so much! What I am now trying to understand is if it is possible to have an additional Top N series within one pivot table. For example, I want to be able to have 2 slicers in one pivot table as follows 1. The number of cars sold to a customer 2. The value of cars sold to a customer and be able to click in-between these.
reply
Mahathma
I had this challenge where I have a date slicers and I have partners data where each partner will sign 1 year agreement. My criteria is I have a date slicer if I select any 1 month I need a chart for the renewal of those partners who expired in the selected month. I want counts by months when they are renewing.
reply
I had this challenge where I have a date slicers and I have partners data where each partner will sign 1 year agreement. My criteria is I have a date slicer if I select any 1 month I need a chart for the renewal of those partners who expired in the selected month. I want counts by months when they are renewing.
reply
Bart
Thank you Mynda. One question: why did not you put the value of the slicer in the -filter- part of the pivot table? (they used to call this the page field earlier). Or is that because the data is in the power pivot? In regular pivot it should work as well....? thanks.
reply
Thank you Mynda. One question: why did not you put the value of the slicer in the -filter- part of the pivot table? (they used to call this the page field earlier). Or is that because the data is in the power pivot? In regular pivot it should work as well....? thanks.
reply
mhalsey
You and your Excel Videos are truly wonderful. I have learned more practical Excel from following along in your videos than I have in any online or self study course. Bless you.
reply
You and your Excel Videos are truly wonderful. I have learned more practical Excel from following along in your videos than I have in any online or self study course. Bless you.
reply
Vijay
I somehow missed this video before, but glad I found and watched it! Thanks Mynda for a very useful and innovative technique which sure is going to help in many scenarios! --
reply
I somehow missed this video before, but glad I found and watched it! Thanks Mynda for a very useful and innovative technique which sure is going to help in many scenarios! --
reply
Matt
Thanks Mynda, there was a lot of good info in this one. If not for the download file, maybe too much in such a brief video. Nonetheless, great info.
reply
Thanks Mynda, there was a lot of good info in this one. If not for the download file, maybe too much in such a brief video. Nonetheless, great info.
reply
Wayne
Awesome Mynda! Thanks for the great lesson and also for providing the sample file to follow along.. very helpful and appreciated! Thumbs up!
reply
Awesome Mynda! Thanks for the great lesson and also for providing the sample file to follow along.. very helpful and appreciated! Thumbs up!
reply
Wellington
It's very useful, Mynda...
Thx for sharing with us something so good and practice!
Keep it up... It's amazing... Thx again!
reply
It's very useful, Mynda...
Thx for sharing with us something so good and practice!
Keep it up... It's amazing... Thx again!
reply
JP
Thank you .It is very useful. But once the top N filter effects be cleared by another slicer , I have to repeat the step 3:50 right ?
reply
Thank you .It is very useful. But once the top N filter effects be cleared by another slicer , I have to repeat the step 3:50 right ?
reply
Add a review, comment
Other channel videos
