Forum Discussion
Aligning records between two visualizations
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
Allan
Thanks v-alq-msft , I uploaded the datasources. Each region has different number of schools, hence my issue.
v-alq-msft , keep in the mind that by 'aligning records' I literally mean having records from both visuals appear in the same line. I was able to achieve this in Tableau and it works when selecting different regions. See example below.
Any insights? I am assuming this is not possible in Power BI.