Forum Discussion
Static Matrix Structure (P&L)
Anonymous
You could try adding an index column for each of your columns to use as "sort column by" (each column by its own index) in the table view.
Something like this:
and see if that maintains the sorting order.
Hi Paul, thanks for your answer.
That's what I tried to do when I created the "DB of Financial Acounts", wich is organized exactly as you said. The problem is when I create a Matrix visual and drag my Drill down levels into it, then PBI organize each line alphabetically as default, and if I use any other column to ordinate by value, I'll get my 1st level accounts all mixed.
Community ChampionAnonymous
You could try adding an index column for each of your columns to use as "sort column by" (each column by its own index) in the table view.
Something like this:
and see if that maintains the sorting order.
Hey Paul.
Sorry for taking that long to reply, I'm involved with other projects so I wasn´t able to work on this for a while.
Apparently your solution is working very well, I'm still not able to dedicate much time to this project, but as far as I tested, you solved it.
Thank you very much !!!