agreed! I sort of found a work around so far but its only been a day since i replicated this so i maybe havent encountered all potential issues haha. I used formulas in my table like this for my sorting for my Primary Key column =IF(ROW()=2, 101, IF([@Account] = OFFSET([@Account], -1, 0), OFFSET([@[Primary Key]], -1, 0), OFFSET([@[Primary Key]], -1, 0) + 1)) I made a primary key column that literally goes from 1 and down until the end, i have my excel tab sorted by the FS order column which i made using this formula so that the income statement is the top always =IF([@[Financial Statement Type]]="Income Statement", 101, IF([@[Financial Statement Type]]="Balance Sheet", 201, IF([@[Financial Statement Type]]="Cash Flow Statement", 301, IF([@[Financial Statement Type]]="Cash Movement", 401, 0)))) then for my levels i did =IF(ROW()=2, 101, IF([@[Level 0]] = OFFSET([@[Level 0]], -1, 0), OFFSET([@[Level 0 Order]], -1, 0), OFFSET([@[Level 0 Order]], -1, 0) + 1)) and so on. These formulas are essentially saying if this rows level 0 is the same/equal to the level 0 cell above it then keep the sort # the same if not add 1. KEY thing though is DO NOT RESORT your data it will mess up your orders to help with that i added a copy and pasted version of the primary key column so if it ever got resorted by accident you have a starting point to resort it and then fix any that got out of order thankfully accounts arent added all that often. SO that being said when you add a new account you can just add a row in where you want it to be sorted so if its cash put it in the middle of your cash accounts or the bottom and those formulas will do their thing to edit the orders below once you add the rest for each level column. Sorry if thats too confusing and probably still not the best solution to make it smoother.

I am having the same issue

I got something to work. I filtered down to literally just one row of data then since it still said i couldnt sort my level 1s to each other i did more googling and i added this SortLevel1 = 'youtablename here'[Level 1 Order] as an added column into the mapping table. Still only one row of data. I then told it to sort my level 1 by this SortLevel1 and it worked i then went and unfiltered everything in powerquery. I did this for each level 1,2,3,4 for my work file. For some reason level 2 it wouldnt let me still so i will try again maybe later but the rest worked. Hope this helps you!!!

I cannot find that in the video either and also want to show value without the negative sign but still want it subtracted.

​@@dpv343 Maybe I missed something but will look at the video againPBIX file along with other video for chasflow he has shared I just liked the entirety of the solution here why I wanted to take this approach. @LondonBusinessAnalyticsGroup any reference would be helpful if you read this comment.

was wondering the same and came up with rewriting the measures (need to repeat for other scenarios as well). Actuals = var calc = CALCULATE([GL Amount Treatas],IncomeStatementLayout[Main Income Statement Line]=TRUE) + [Blank Line] var _sign = IF(Selectedvalue(Mapping[Value]) = "+", 1, -1) Return calc * _sign

@@zyzt3m I tried various methods but nothing worked. When I use lot of measures the dashboard will crash saying resource exceeded. Went with the option to precalculated everything in DB and then bring the data in powerbi. We had another requirement for user level security so the data had to be very granular to do rollups based on access.