Creating a specific range for a visual table referencing the table not the data

[Zam132]

Ok so - I have a large dataset, for my visiual table, I have the name of the individuals in one column and the sum of their profits in another (PowerBi is automatically summing their collective profits which is what I want). However, I want the visual to only show the top 50 individuals based on their profit. Would there be a way to filter this visual even though the sum of the individuals profits are not within the dataset?

[Anonymous]

Hi @Zam132 ,

To show the top 50 individuals based on their profit, you can use a top N filter in the visual level filters pane. Here are the steps to do that:

• Select the visual table that you want to filter.
• Go to the Filters pane on the right side of the report window.
• Under Visual level filters, expand the name of the individuals column.
• Click on the drop-down arrow next to Basic filtering and select Top N.
• In the Show items box, enter 50.
• In the By value box, select the sum of profits column.
• Click Apply filter.

How to Get Your Question Answered Quickly 

If I have misunderstood your meaning , please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.