Programatically sorting card visuals

[Anonymous]

I am trying to figure out if there is a way to sort the card visuals alphanumerically or by a different field like cost. 

I have figured out how to give the illusion of sorting by creating two groups of cards.  Sort data by name then create index, then sort by cost column then create another index for cost.  I assign  group one  a set of indexes and then group two the next set.  each box contains program names and is filtered by index number so box 1 only shows index 1 and so forth.  Then I use bookmarks and hide cost group and apply it to ABC button then hide alpha group and apply to Cost button.

I know I can use tables but prefer box look.  I can use the above approach but wonder if there is a way to change what is shown in each box when a user selects the buttom using a more programatic approach.

Thanks

[Anonymous]

Program	Index	Sort Type	Cost
Program A	2	Cost	100
Program A	1	Alpha	100
Program B	1	Cost	50
Program B	2	Alpha	50
Program C	3	Cost	700
Program C	3	Alpha	700

Example  of what I think the table would look like above. The card would switch values based on what sort button the user selected so Box 1 would be filtered to only show indexes of 1 but if user selects cost would show Program B in box 1, but if Alpha is chosen then Program A would display.

[danextian]

Hi @Anonymous ,

It would be very tasky if  your use case involved multiple sorting options but have you tried using bookmarks?

[Anonymous]

yes I've found a solution where i use bookmarks to "sort" the cards. but trying to figure out if there is a way to use a measure or calculated field to update the cards.  

[Anonymous · Accepted solution]

found another work around, I just created an additional table for each field that I wanted to sort the boxes by.  I sorted each column then added an Index column for hi-lo, lo-hi, a-z, z-a and a SortType.  I then appended the "sorting" tables into one table.  On the report each box is assigned an index number, the there is a SortType slicer that changes what the Programs are sorted by. Would still like to know if there is simplier way but this might be cleaner visual-wise than the 1st option I tried.