Sorting the value in slicer chart

[RIDWIV]

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.

[collinsg]

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]

Hello,

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