Forum Discussion
Helper IVFilter Visualization to include top 10 only
So, I don't have exact info on what you have but can point you to it. Select your visual. Underneath VISUALIZATIONS pane you should see a section called FILTERS. Within that section there is a "Visual level filters" area and it should include every column and measure that you have in your visual. Let's say you have a Column1 and a Column2 in a table. You want the Top N of Column1 (category of something) based upon Column2 (value). Hover over Column1 and click the drop down arrow. Under "Filter Type", click the drop down and choose "Top N". For "Show items" leave the drop down at "Top" and put in the top number of items you want, let's say 10. In the "By value" area drag in your Column or Measure that you want the "top" to be based on. Click "Apply filter".
Community ChampionEasiest way in the Filters area use Top N filtering.
gusdahu
Greg_Deckler wrote:Easiest way in the Filters area use Top N filtering.
Where would I find this filter?Regards,
Gus
- Greg_Deckler
So, I don't have exact info on what you have but can point you to it. Select your visual. Underneath VISUALIZATIONS pane you should see a section called FILTERS. Within that section there is a "Visual level filters" area and it should include every column and measure that you have in your visual. Let's say you have a Column1 and a Column2 in a table. You want the Top N of Column1 (category of something) based upon Column2 (value). Hover over Column1 and click the drop down arrow. Under "Filter Type", click the drop down and choose "Top N". For "Show items" leave the drop down at "Top" and put in the top number of items you want, let's say 10. In the "By value" area drag in your Column or Measure that you want the "top" to be based on. Click "Apply filter".
- gusdahu
This worked! Thanks Greg!