Forum Discussion

diogobraga2's avatar
diogobraga2
Helper IV
6 years ago

Aligning records between two visualizations

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 ...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

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

diogobraga2's avatar
diogobraga2
Helper IV
6 years ago

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

  • diogobraga2's avatar
    diogobraga2
    Helper IV
    6 years ago

    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. 

     

    • diogobraga2's avatar
      diogobraga2
      Helper IV
      6 years ago

      Any insights? I am assuming this is not possible in Power BI.

      • v-alq-msft's avatar
        v-alq-msft
        Community Support
        6 years ago

        Hi, diogobraga2 

        I have tried serval times. You can keep the order of corresponding column same. However, It is unsupported to align the corresponding records. You may post a new idea in Idea Forum, and add your comments there to improve Power BI for making this feature coming sooner. Here is the link. Thanks.

         

        https://ideas.powerbi.com/forums/265200-power-bi-ideas

         

        Best Regards

        Allan