Presentation order with different levels

[CasperSV]

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

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

[v-henryk-mstf]

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]

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