Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
It seemed quite trivial but I do not manage to sort ascending/descending values in my matrix's columns
I have several financial KPIs, for each I have actual and budget values. I created a matrix as follows:
But I can't sort the values ascending/descending by just clicking either Actuals or Budget in the KPI I want
But if I take out "Financial Account" from columns, it works (but the values are obviously meaningless as it sums up several different KPI
Anything I am missing ? it seems to be a very simple thing...
Otherwise I though of creating a measure for each combination:
- Contract Margin Actuals
- Contract Margin Budget
- Sales Actuals
- Sales Budget
- ...
And put them in "Values" field in the Matrix, so as I can sort individually for each measure...
Any hint?
Thank you very much for your help,
TB
@Anonymous , Multi-column sorting is not there for matrix yet.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |