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
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