Forum Discussion
Creating a specific range for a visual table referencing the table not the data
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?
1 Reply
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
