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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Matrix - Sort columns by value

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.
Status: Needs Votes
Comments
cindy_l_botchis
New Member
Many of our visuals are done by value then year in the matrix form and this is not possible in Power BI without messing with the tables. We've been instructed to switch from Tableau to Power BI, but without this simple item, it won't be happening. Instead of: 2021 2022 Market Revenue Company Revenue Share % Market Revenue Company Revenue Share % We need: Market Revenue Company Revenue Share % 2021 2022 2021 2022 2021 2022
abnbenitez1
New Member

needed when crossfiltering between tables and matrix. matrix provides one vision and the detail is in the tables.

fbcideas_migusr
New Member

It's 2023... is this still not an option?

kiran_kum_ashte
New Member

Matrix - Sort columns by value

Could you please make this happen or maybe come up with the new Matrix visual itself?

kiran_kum_ashte
New Member

Scheduled Refresh -Time

We 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.

fbcideas_migusr
New Member

This is such a basic gap in this experience I'm surprised it's still not closed.

GEvans2
New Member

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.

fbcideas_migusr
New Member

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).

m_baghi1
New Member

Yes, this helps us a lot

theresa_goenawa
New Member

Please work to add this feature, we really need this