Forum Discussion

RIDWIV's avatar
RIDWIV
Helper I
3 years ago

Sorting the value in slicer chart

Hello all,

Hope you are doing good.

I am encountering one issue i want to arrange ip address in slicer chart as per the count of user id. For example if any ip address is having 5 user id(hit made to particular ip address 5 times) it should come in first position, ip address having 4 user id count(hit) it should come in second position and so on.

How many IP address hit per client. That count should reflect in slicer and can be ascending and descending way.

 

 

 

 

Tutorial Requests

2 Replies

  • collinsg's avatar
    collinsg
    Solution Sage
    3 years ago

    Good-day RIDWIV 

    Here are some steps which should achieve your goal.

    1. Group by IP address (and check the "Advanced" option).
    2. For the aggregations 
      1. Add a column "Count of Users", with operation = Count Rows.
      2. Add a column "All Rows", with operation = All Rows.
    3. Expand the "All Rows" column
      1. Uncheck "Use original column names as prefix".
      2. Select all columns except IP address.
    4. Load to the data model and switch to "Data View".
    5. In Data View select the IP column and from the "Column Tools" ribbon choose "Sort by Column".
    6. Sort by Count of Users.
    7. Insert your slicer visual and click the ellipsis to bring up a menu with "Sort axis" as an option. Sort ascending or descending as you please.

    Hope this helps

     

    Setting the grouping

     

    The result

     

    • RIDWIV's avatar
      RIDWIV
      Helper I
      3 years ago

      Hello,

       

      Thank you for sharing the information. But I want value in slicer to be organised in ascending or descending order.