Forum Discussion

mherrick's avatar
mherrick
Regular Visitor
8 years ago
Solved

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...
  • TomMartens's avatar
    TomMartens
    8 years ago

    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

TomMartens's avatar
TomMartens
Super User
8 years ago

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

  • mherrick's avatar
    mherrick
    Regular Visitor
    8 years ago

    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

    • TomMartens's avatar
      TomMartens
      Super User
      8 years ago

      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

      • mherrick's avatar
        mherrick
        Regular Visitor
        8 years ago

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