Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have Matrix Visual and want to sort the coloumns by below critieria-
first, if Impact is Yes , then it should come at the top, then by Date 1 then Date 2and then Date 3 in Ascending order-
INPUT-
Hi,
In the matrix visual, click on the Impact column, hold the Shift key and click on the Date column and so on.
@Ashish_Mathur Tried this, but the Blanks in date column are coming at the very top.
Hi,
Expand the filter pane and filter out the blanks from each of the Date columns.
@Ashish_Mathur I need the blanks as well in the date coloumn as there are more additional columns in the report that has data to be displayed.
Hi,
When you click on the heading a second time, then the sort order changes.
I'm afraid there is no easy way to do this.. The below alternative solution should help.
How to Custom Sort Multiple Columns in Power BI | MiTutorials - YouTube
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |