on 04 Jul 2018 16:15:04
Matrix currently doesn't allow you to sort the columns based on designating values as being a priority above the column field names
I want to put the values above the column header. In the first row (of the column headers) the measures I've created, then all the months for each measure. In this moment I have first the months and the measures for each month separately.
- Comments (2)
RE: Move up values field on column matrix
The workaround won't work if we have row groups and need different aggregation methods for each item in the attribute and value columns (i.e. Market Value and Bond Coupon). This feature is important for people in financial industry creating reports for portfolios. Where the standard has been showing Portfolio/Benchmark/Difference below each items/measures
RE: Move up values field on column matrix
I'm surprised this doesn't have more votes. While there is a work around to create filtered measures to overcome this, it significantly reduces the end user experience for those end users who cannot write DAX. It also creates a large number of seemingly unnecessary measures.
Would love for this to be added, especially if it's a quick fix.