Forum Discussion
Waterfall total different from calculated measure
Hi HotChilli thanks but I think I was not clear.
What I meant is that the results won't be organized in the correct order but instead, from low to high based on the amount, whether I select Category or Y Axis as sort by.
The category is ordered by the ID, so it should respect the ID and not the + or - amount.
Sort by Account (Category)Sort by "Waterfall" Measure (Y Axis)
The support table has 2 values support table - without relationships
The new formula is
Waterfall =
SWITCH(TRUE();
SELECTEDVALUE(AxisSupport[Account])="account1";[account1];
SELECTEDVALUE(AxisSupport[Account])="account14";[Consolidated Actual])
Community ChampionWhat I'm referring to is the https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button feature. You want to sort by Account but you have to tell powerbi how you want it sorted.
Your data model could probably be simplified since all tables look practically the same (unless that's just test data and your real data requires the model)
Hi HotChilli , in both examples the data is sorted by the feature you suggested.
The problem is none of the solutions I could come up with show me what I need.
In the first example I had the problem that the total is not what I want:
And the second example, in which I did a support table for the axis, PBI don't respect the sort by column feature. It only sort by amounts and not account order.