Slice list: add another column in the table as a Tooltip and sort by it?

[simonxiaoss]

If the table's two columns have unique number, then we can sort the list by another column. But if they are not unique, then how do sort one list of content from column A based on value of coumn B?

Example:

-------------------------

Name      |     Quantiry

-------------------------

XXXX       |    5

YYYY       |    50

XXXX       |    17

ZZZZ       |    8

AAAA      |    5

ZZZZ       |    88

-------------------------

Now, I know that, the list contains names of

"AAAA": total is: 5

"XXXX": total is: 22  

"YYYY": total is: 50

"ZZZZ": total is: 96

So, I put the names in a single-seclection list, and I would like to sort this list based on the total (sum(Quantiry)), like below:

"ZZZZ"

"YYYY"

"XXXX"

"AAAA"

Is there a easy way to do this?

//I think I can create a new tables which just save the sum'ed names/quantity then use slice to display/sort it.

Is there a way, just like a "Stacked Bar Chart", I put the sum of Quantity to the Tooltip field, then from the chart right-top corner "..." , select "Sort By" this Tooltip field?

[amitchandak]

@simonxiaoss , You can sort you visual on sum(Table[Quantity])

For tooltip

or create a report tooltip, there you create a table with name and sum(Table[Quantity]) and sort that on sum(Table[Quantity])

https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

[simonxiaoss]

>> "You can visually sort in sum (Table [Quantity])"

How to sort this in a "single selection slicer list"?

By the way, Can someone hekp me understand why all of my messages are showing with Spanish? And my post are put into "Translated Spanish Desktop"?

[simonxiaoss]

[simonxiaoss]

Anyone to help please?