Forum Discussion
Aligning records between two visualizations
Hi, diogobraga2
Based on your description, I tried to open the link you provided but failed. So I created visuals based on some other sample data to reproduce the scenario.
Firstly, you can click ‘Edit Query’, go to query Editor, choose ‘Add Column’, select ‘Index Column’, click ‘Close and Apply’.
Secondly, In my example the target column is ‘ProductName’. You may select the target column, choose ‘Modeling’ , click ‘Sort by Column’, make ‘Index’ selected.
Result:
If I misunderstand your thought, please show me your sample data. I am glad to solve the problem for you.
Best Regards,
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-alq-msft thanks for your help. For me, it gets challenging when applying the region filter. Can you please check and show your solution in the sample pbix provided?
Here's the link, let me know if you can't open it.
https://drive.google.com/open?id=1DAJ_r1p9LsgTqANchQQ3CcEcT_En6tLF
Hi, @diogobraga2
Thank you for providing your pbix file. However, I can't create index column in Query Editor because I have no access to datasource.
It is easy to operate as my last reply. You may create an index column in Query Editor. Then you can make 'School Code' column selected. Finally, you may click 'Sort by Column' and select the 'Index' column in the 'Modeling' area.
You can try to do it as above and tell me the reslut. Thanks.
Best Regards
AllanThanks v-alq-msft , I uploaded the datasources. Each region has different number of schools, hence my issue.
