Forum Discussion
Helper IVCalculate difference between columns in the matrix
Found a solution.
In case anyone stucked here is a good starting point: Solved: Difference instead of Total in PowerBI Matrix - Microsoft Fabric Community
Super UserI would go with Visual Calculations - they have a concept of PREVIOUS where you can look sideways in a visual and compare to the neighboring values.
Helper IVnot sure it will work either as we want to have one column for difference and one for diff%, not category columns split by new columns,..
- lbendlin
Correct, you can only abuse the Column Totals once.
You would be looking into creating a custom matrix with a reference table for the desired column names and a measure to do the switching. This becomes very ugly very quickly and is frankly not worth the effort.
- Kopek
so.. there is no simple solution to this ?
looks like it should not be that complicated... total is computed somehow, so why we are not ab;eto overwitte it with difference or something like this ?:(
- lbendlin
Because as you said - you would have to add the additional measures to each of the columns (categories). You cannot "add columns to a matrix" - that's not a thing. Power BI is not Excel.