Forum Discussion

erichard00's avatar
erichard00
Frequent Visitor
8 years ago

chiclet slicer

Using the chiclet slicer with 15-20 buttons where preserving the sort order I need is crucial... No matter what I do (sorting the data in edit query, adding a column to sort on, the new option to per...
OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
8 years ago

Hi erichard00

 

I'm not sure if this is exactly something you've tried, but I seem to be able to control the sort order by dragging a numerical "Order" column into the Values field of the Chiclet Slicer, then choosing "Sort by Order" in the Chiclet Slicer menu.

 

Here is an example with a flags table with Base64 image URLs with a made-up Order column.

 

The sort order here seemed to persist after I published to the Service.

 

https://www.dropbox.com/s/9rw1n54krbtun3a/Chiclet%20Slicer%20Order.pbix?dl=0