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 ...

Tutorial Requests

collinsg

Solution Sage

3 years ago

Good-day RIDWIV

Here are some steps which should achieve your goal.

Group by IP address (and check the "Advanced" option).
For the aggregations
1. Add a column "Count of Users", with operation = Count Rows.
2. Add a column "All Rows", with operation = All Rows.
Expand the "All Rows" column
1. Uncheck "Use original column names as prefix".
2. Select all columns except IP address.
Load to the data model and switch to "Data View".
In Data View select the IP column and from the "Column Tools" ribbon choose "Sort by Column".
Sort by Count of Users.
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