We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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:
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 38 | |
| 33 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 67 | |
| 62 | |
| 38 | |
| 34 | |
| 22 |