Forum Discussion
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
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!
Super UserHey,
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
Got it! Working now. Thank you so, so much!
- TomMartensPerfect!