Forum Discussion
Sorting Calculation Group within Headers
Try this solution that utilizes a fields parameter. Each measure needs to be created, since a calculation group doesn't seem to allow sorting on a specific column as you indicated.
1. Create the table Topic with each topic and its associated measure names:
2. Create a fields parameter with each measure listed in the table above. Uncheck "Add slicer to this page".
3. Create a relationship between Topic and TopicParameter. The default is bidirectional, but I changed it to unidirectional (I avoid bidirectional relationships whenever possible).
4. Create a matrix and add TopicParameter to the Values field well:
5. Create a slicer using Topic[Topic].
6. Sort by any matrix column:
Try this solution that utilizes a fields parameter. Each measure needs to be created, since a calculation group doesn't seem to allow sorting on a specific column as you indicated.
1. Create the table Topic with each topic and its associated measure names:
2. Create a fields parameter with each measure listed in the table above. Uncheck "Add slicer to this page".
3. Create a relationship between Topic and TopicParameter. The default is bidirectional, but I changed it to unidirectional (I avoid bidirectional relationships whenever possible).
4. Create a matrix and add TopicParameter to the Values field well:
5. Create a slicer using Topic[Topic].
6. Sort by any matrix column: