Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Marina
Frequent Visitor

Slicer sorting on different pages

Hi,

I need to sort slicer in 2 different ways for two different reports. Is it possible?

I have lookup table with value, index1 for the first order sorting and index2 for the second order sorting of values.

Sorting sclicer by column is working for all pages. But I need different sort order for each page.

 

Thanks for any advice!

 

1 ACCEPTED SOLUTION
Sean
Community Champion
Community Champion

@Marina

 

Try concatenating as in my answer here...

 

http://community.powerbi.com/t5/Desktop/sort-by-custom-Index-order/m-p/27823/highlight/true#M9115

 

Let me know if this helps!

EDIT: => You obviously will have to do this twice - once for each Custom Order!

 

Sort Slicer 3.png

 

View solution in original post

2 REPLIES 2
Sean
Community Champion
Community Champion

@Marina

 

Try concatenating as in my answer here...

 

http://community.powerbi.com/t5/Desktop/sort-by-custom-Index-order/m-p/27823/highlight/true#M9115

 

Let me know if this helps!

EDIT: => You obviously will have to do this twice - once for each Custom Order!

 

Sort Slicer 3.png

 

Marina
Frequent Visitor

It works! Thank you very much!! 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.