Need to display Top 5 and Bottom Visual 5 by using Slicer

[kvenkatesh369]

Hi Team,

I want to display top5 and bottom 5 in a visual separately by using a slicer.
Slicer Should have 1 2 3 4 5 number, these numbers are heirarichal from Top and Bottom.

The moment when i select top or bottom in the category the slicer should give me 1 2 3 4 5 numbers,
these numbers should act on the visual where i want to show my result.

ex: if i select Top 5 Slicer should show 1 2 3 4 5 numbers, if i select 4 from the slicer the visual should show 4 Bars/Columns accordingly.

[VahidDM]

Hi @kvenkatesh369 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

[kvenkatesh369]

Hi VahidDM,

I will try to explain you the issue which i was facing . Here i am able to show Top 5 and Bottom 5 Vendor by Accepted % with help of Bookmarks, But i need to do this without taking the Bookmarks.  

I am able to show individually top 5 and bottom 5 vendor in Clustered bar chart.

here i have created Top, Bottom row(TOP BOTTOM table) and S.NO 1,2,3,...10(ROW Table) 

i took one slicer for top,bottom and another slicer for S.no 1,2,3,...10

eg: if i select TOP in one slicer and 5 in another slicer i need to show TOP 5 Vendors in the clustered bar chart

eg: if i select BOTTOM in one slicer and 9 in another slicer i need to show BOTTOM 9 Vendors in the clustered bar chart

[v-yiruan-msft]

Hi @kvenkatesh369 ,

Please review the following links and check whether they are what you want.

Show Top Or Bottom Results Using Ranking In Power BI

How to drive the Top/Bottom 10 Customers.

How To Use Top N and Bottom N In Power BI

If the above ones can't help you get the expected result, please provide some sample data(exclude sensitive data) and your final desired result with backend logic and special examples. It is better if you can provide a simplified pbix file. Thank you.

Best Regards