cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mherrick Frequent Visitor
Frequent Visitor

Top / Bottom N & Selected

Hi I'm looking to create a chart that shows Top N, Bottom N (regardless of slicer selection) and a selected value (by a slicer) as the X-Axis. I've solved the Top and Bottom N part just fine. However, having trouble w/ the selected value portion. If I remove interactions w/ the slicer it shows all as the selected value; if I keep the filter on, it shows only selected... Please help! 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Re: Top / Bottom N & Selected

Hey,

 

thanks for sharing the data, now I understand your requirement.

Due to the time this is not a direct solution, but maybe this can give you an idea:

https://www.minceddata.info/2018/06/06/topsomething-and-all-the-rest-called-other/

 

If this will not help, I will take a closer look tomorrow evening - sorry for that.

 

Create an unrelated table that contains all the cities.

Create two tables TOPN, BOTTOMN and add the selected value from the slicer using ROW (check if the value is already in the new table, using CONTAINS(...)), then use this "new" table to map the cities to the unrelated table (used as axis for the visuals).

 

Hopefully this gives you an idea how to solve this

 

Regards

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!

View solution in original post

5 REPLIES 5
Super User III
Super User III

Re: Top / Bottom N & Selected

Hey,

 

I have to admit that I'm not fully understand your requirement.

 

Please create sample data, upload the resulting pbix file to onedrive or dropbox and share the link to the pbix file.

 

Regards

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
mherrick Frequent Visitor
Frequent Visitor

Re: Top / Bottom N & Selected

Thank you so much for responding. Please see the below link for a test file. If there's anything else I can provide, let me know!

 

test.pbix

Super User III
Super User III

Re: Top / Bottom N & Selected

Hey,

 

thanks for sharing the data, now I understand your requirement.

Due to the time this is not a direct solution, but maybe this can give you an idea:

https://www.minceddata.info/2018/06/06/topsomething-and-all-the-rest-called-other/

 

If this will not help, I will take a closer look tomorrow evening - sorry for that.

 

Create an unrelated table that contains all the cities.

Create two tables TOPN, BOTTOMN and add the selected value from the slicer using ROW (check if the value is already in the new table, using CONTAINS(...)), then use this "new" table to map the cities to the unrelated table (used as axis for the visuals).

 

Hopefully this gives you an idea how to solve this

 

Regards

Tom

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!

View solution in original post

mherrick Frequent Visitor
Frequent Visitor

Re: Top / Bottom N & Selected

Got it! Working now. Thank you so, so much! 

Super User III
Super User III

Re: Top / Bottom N & Selected

Perfect!
Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors