Aligning records between two visualizations

Question

What is the best way to align records from different visuals in Power BI? The pbix file is here.

See the example below, there is a matrix and a 100% stacked bar visuals that needs to be aligned by school name, including when school names change when the Region filter is applied.

v-alq-msft · Answer

Hi, diogobraga2&nbsp;&nbsp;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.&nbsp;Result:If I misunderstand your thought, please show me your sample data. I am glad to solve the problem for you.&nbsp;Best Regards,Allan&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

diogobraga2 · Answer

v-alq-msft&nbsp;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?&nbsp;&nbsp;Here's the link, let me know if you can't open it.&nbsp;https://drive.google.com/open?id=1DAJ_r1p9LsgTqANchQQ3CcEcT_En6tLF&nbsp;&nbsp;&nbsp;

v-alq-msft · Answer

Hi, @diogobraga2&nbsp;&nbsp;Thank you for providing your pbix file. However, I can't create index column in Query Editor because I have no access to datasource.&nbsp;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.&nbsp;You can try to do it as above and tell me the reslut. Thanks.&nbsp;Best RegardsAllan

diogobraga2 · Answer

Thanks&nbsp;v-alq-msft&nbsp;, I uploaded the datasources. Each region has different number of schools, hence my issue.

diogobraga2 · Answer

v-alq-msft&nbsp;, 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.&nbsp;&nbsp;

Forum Discussion

Aligning records between two visualizations

8 Replies

Related content

matrix visual value alignment

Horizontal alignment in Power BI Table visual

Alignment of an image

Tachometer alignment

Card Visual - Right Alignment of Data