Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Sorting with in regions Group

Hello,

 

I have problem with power BI.I have 3 regions with different states .I created a report according their populations.

 In axis I take regions ,in legends I put their states.Can we sort based on states with in regions?

 

 

Thanks,

Chunduri

 

 

Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Anonymous,

     

    You can go through the URL I provided in my previous post. From v-haibl-msft's post, you can see we can create a custom table to sort country based on desired order, then in fact table, we can set state sort by this custom order. 

     

     

    By the way, though the pbix file created in the latest desktop version and prompt message pops out to suggest update desktop version, you should be able to open the report finally. 

     

    Best Regards,
    Qiuyun Yu 

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks for reply @Qiuyun Yu ,

       

      The file what you send is not opened because my desktop does not have  latest version. could you please explain the procedure.

       

      Thanks,

      Chunduri

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        8 years ago

        Hi Anonymous,

         

        You can go through the URL I provided in my previous post. From v-haibl-msft's post, you can see we can create a custom table to sort country based on desired order, then in fact table, we can set state sort by this custom order. 

         

         

        By the way, though the pbix file created in the latest desktop version and prompt message pops out to suggest update desktop version, you should be able to open the report finally. 

         

        Best Regards,
        Qiuyun Yu