Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi!
Case:
I have a matrix that has two levels of data in columns and two in rows. And for this I have a measure as Value.
Problem:
How do you sort rows based on another measure that doesn't appear in Value? In other visualizations (bar chart etc.) you can use the tooltip and sort. In the matrix, unfortunately, there is no such option.
Has anyone had a similar problem?
Thank you in advance.
BR
Solved! Go to Solution.
You may take a look at the post below.
Another way is to add sort measure to the matrix and sort by it. And finally hide the column by just dragging the column width to be very small.
@baghdadi62 wrote:Another way is to add sort measure to the matrix and sort by it. And finally hide the column by just dragging the column width to be very small.
Unfortunately, I can't do this because I have two levels of data in columns and rows, and for each additional column will be added containing values for this measure and I would have to hide all columns every time.
Unfortunately, after adding a new measure it looks like this. And I'd like to sort the rows based on Sum of Sales Amount for Total, so that you can't see Sum of Sales Amount.
You may take a look at the post below.
Hi,
in the matrix you cannot sort columns or rows by measures. But you can use sort by column. consider that only column can use in Sort by Column:
baghdadi62, I can sort in PBI based on the measure I use in the matrix. But I can't find a way to sort based on another measure (which can be added in a tooltip, e.g. a bar chart).
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
79 | |
65 | |
62 | |
60 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
66 |