Matrix currently doesn't allow you to sort the columns based on designating values as being a priority above the column field names.
For example, my field in the columns section results in three columns. If you add two sets of values, you are forced to see: Column 1, Value 1, Value 2, Column 2, Value 1, Value 2, etc. Like in a Pivot Table, you should be able to prioritize values so that it shows as: Column 1, Column 2, Column 3, Value 1, Column 1, Column 2, Column 3, Value 2.
- Comments (73)
RE: Matrix - Sort columns by value
This is basic requirement that should have been implemented a long time ago. Imagine if you have long list of records there that you need sort by specific column. Would be very helpful.
RE: Matrix - Sort columns by value
This is very basic functionality and pending from year 2016. Please implement this as early as possible.
RE: Matrix - Sort columns by value
Basic functionality available in other BI tools still lacking here. Should be one of priorities.
RE: Matrix - Sort columns by value
Please work to add this feature, we really need this
RE: Matrix - Sort columns by value
Yes, this helps us a lot
RE: Matrix - Sort columns by value
in AppSource, the "Zebra Tables 6.6" has this feature, to bad it is not free... and that visual is lacking other good features, like conditionally formatting the color of values for example (as of today at least).
RE: Matrix - Sort columns by value
We really need all matrix columns to be sortable when the values are based on one field, as they are in a table or in a matrix where every column is based on a separate value field. Tables are difficult to work with in other ways (e.g. you'd need to add a measure for every column instead of just one for all columns), so we can't use those.
RE: Matrix - Sort columns by value
This is such a basic gap in this experience I'm surprised it's still not closed.
RE: Matrix - Sort columns by value
Scheduled Refresh -TimeWe are able to select Time, for example, 9:00AM or 9:30 AM or 10:00 am or 10:30 am and so on for 48 times in a day.However If we can have option to choose 9:15 am and 9:45 am and 10:15 am and 10:45 am, It would have been better. we are fine with 48 times in day.
RE: Matrix - Sort columns by value
Matrix - Sort columns by valueCould you please make this happen or maybe come up with the new Matrix visual itself?