Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Move up values field on column matrix

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.
Status: Needs Votes
Comments
kirstyclark
New Member
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.
nelsonwhyu2
New Member
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
Derek_Cook
New Member

Seems to be an obvious one. I can do this in pivot tables and I had no problem doing this in Qlik Sense at my previous job.

fbcideas_migusr
New Member
Status changed to: Needs Votes