Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Custom / dynamic sorting based on slicer value

Hello!   I have problem which I don't know how to fix it. I am making report about bus traffic. There are different 6 routes and all of them are using few same bus stops in the middle of the route....
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Could you provide a simple PBIX file for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello

 

Thanks for answering. I made a demo pbix for you but I don't know how to send here. But here is two pictures.

First table contains:

 

  • trip_id (connects to route_id in other table)
  • stop_sequence (unique sequence for stopping order per trip and per stop
  • stop_id for every stop
  • direction_label

What I need is to get stop_id's to correct order based on directions stopping sequence. Every direction has own unique stopping sequence. So when I selected "A to B" from slicer stop_id's in bar charts has to get into correct order. When all directions are selected it does not matter in which order stops then are. Only when single direction value is selected.

 

Second table has stop id's, names and correct stop/sort order but it is manually made in excel so it is fixed. I need dynamical sorting based on direction -> trip_id -> stop_sequence.

 

Thanks!