Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am unable to figure out how to sort this matrix based on the date ranges below. I have tried a custom sort but that did not seem to work. Any ideas?
Solved! Go to Solution.
You could use the "Sort by Column" icon (just select the field you want to sort first):
Or, click the 3rd icon on the left:
On the Modeling View, in the field list, select Range, then set the Sort by Column to the Index.
Hope this helps,
Nathan
Nathan,
I'm not sure how you got to that screen.
Your date ranges are all in the "value" section of the matrix correct?
No, I am trying to get a count of Service Calls within a certain range, 0-30, 31-60.....
I believe this is a similar issue to yours.
https://community.powerbi.com/t5/Desktop/Filtering-matrix-rows-by-a-column-value/td-p/225092
I will give this a try.
You can get to the Modeling View with this icon:
OK, I belive I know why I do not see that icon, it's because I am using a version optimized to allow me to save to our Power BI Report Server.
The Matrix visual lacks functionality. There are lots of ideas on the community site. Below are the front runners. Please vote these up!
I must have an older version as I do not have that icon.
You could use the "Sort by Column" icon (just select the field you want to sort first):
Or, click the 3rd icon on the left:
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |