Forum Discussion

emman_burgonia's avatar
emman_burgonia
Frequent Visitor
4 years ago
Solved

Arrange Columns in Matrix Visual and Show the Top 10 rows

Hi all,    I have a question about arranging the columns in Matrix in Power BI. I have tried creating a new table with indeces however it's still not working. Is it possible that because the value ...
Need Help
Show and Tell
  • PijushRoy's avatar
    PijushRoy
    3 years ago

    Hi emman_burgonia 

    Please find the solution below and pbix file.

    STEPS

    Enter New Table and New Calculation Column for overwrite Other to Standard Enrollment

    Change sort order

     

    After that Add another calculated column in Data table to overwrite Other to Standard Enrollment
    Create relationship
    Plot data (find pbix)


    Let me know, it works or not

    If solve your requirement, please mark this answer as SOLUTION
    If this comment helps you, please LIKE this comment/Kudos

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
4 years ago

Hi emman_burgonia 

 

Please create a lookup table for "Enrollment Data Age" and add one column for "Sort"
Create a relationship with your data table
Use value from Lookup Table in Column for the Matric table and change the sort order.

For top10 highest number of school, you need to create RANK for the school and use the RANK in filter pane.

Hope you get idea to solve the requirement.
If you face any issue, please share sample PBIX after removing sensitive data.

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

 

  • emman_burgonia's avatar
    emman_burgonia
    Frequent Visitor
    3 years ago

    Hi PijushRoy thanks for your assistance. I tried working on that but it seems that I cannot get the output that I want. I have attached here the link.

    • PijushRoy's avatar
      PijushRoy
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Hi emman_burgonia 

      Please find the solution below and pbix file.

      STEPS

      Enter New Table and New Calculation Column for overwrite Other to Standard Enrollment

      Change sort order

       

      After that Add another calculated column in Data table to overwrite Other to Standard Enrollment
      Create relationship
      Plot data (find pbix)


      Let me know, it works or not

      If solve your requirement, please mark this answer as SOLUTION
      If this comment helps you, please LIKE this comment/Kudos

      • emman_burgonia's avatar
        emman_burgonia
        Frequent Visitor
        3 years ago

        Hi PijushRoy, 

         

        Thank you so much! This works perfectly.