Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Below is the screenshot where left part is the data, and right part is the result.
I need to sort the columns descending (i.e Budget 2018 , 201801, 201802, 201803)
The visual used here is the matrix. (pivot table)
I have tried sorting with the index column, but still not able to get accurate result.
Any help is appreciated,
Thanks in advance !!
Solved! Go to Solution.
@Anonymous ,
Change the Index of "Budget 2018" from 4 to 0.
@Anonymous ,
Change the Index of "Budget 2018" from 4 to 0.
Thanks @v-chuncz-msft!! ,
It worked, but this is quick fix.
What if I receive data for "2020" and "budget 2020" again I need to put indexing and change the index manually.
| User | Count |
|---|---|
| 51 | |
| 39 | |
| 29 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 66 | |
| 56 | |
| 40 | |
| 21 | |
| 19 |