Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Get Top 5 Records in Power BI Table View Including Grouped Values

I am using my below table visual. I need to get the top 5 records based on current exposure amount field. The top 5 condition should be including the group fileds Group name, updated orr and indus...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

CTozzi  In your sample data keep additional entry for Group 5 with other ORR and Industry.

 

Example :- Group 5 -- ORR 7 -- Industry 6 -- 100400

 

After addition, see what happens. It will show you 6 records instead of 5. That is my problem.

CTozzi's avatar
CTozzi
Resolver I
5 years ago

Anonymous what if you change the visualization to a Matrix? Then you can choose to collapse each group line. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    CTozzi  No. Not looking for matrix visuals.