Forum Discussion

CasperSV's avatar
CasperSV
Helper II
4 years ago

Presentation order with different levels

Hi guys,

 

I am trying to create a matrix with different level categories and with a specific presentation order. 

It is difficult because the categories and presentation order comes from a different table, I got help here to connect the tables:

https://community.powerbi.com/t5/Desktop/Connecting-G-L-Account-categories-with-chart-of-accounts/td-p/2378278

 

However, now the categories need to be sorted based on the presentation order (viewing order) and I am not able to do it because there is an error with circular independency. 

 

Current matrix:

 

Desired order:

 

How can i upload an attachment btw? 

https://file.io/eUPI5LTL19Pi 

 

Thank you in advance!

Best regards,

Casper

 

Need Help

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi CasperSV ,

     

    You can post the url of the uploaded pbix shared file in the reply. Easy for me to download and make test. Looking forward to your reply.


    Best Regards,
    Henry

     

    • CasperSV's avatar
      CasperSV
      Helper II
      4 years ago

      hi v-henryk-mstf 

       

      I am sorry, I think I cannot upload files. I have read that only superusers are allowed to do so.

      I have uploaded the file on Ufile.io. You can download it for free with a slow download..

      I am sorry, I do not know a better way to share the test pbix..

       

      https://ufile.io/pyh7s1i3

       

      Thanks in advance!

      Casper